﻿using System;
using System.Data;
using Model;
using DBUtility;

namespace DAL
{
     /// <summary>
     /// 数据访问层RESULT_LAMP_DAL
     /// </summary>
     public class RESULT_LAMP_DAL
     {
         public RESULT_LAMP_DAL()
         {
         }


         /// <summary>
         /// 得到最大JCLSH
         /// </summary>
         public string GetMax_JCLSH(string p_strWhere)
         {
             string strResult = "0";
             string strSql = "select max(JCLSH) as m from RESULT_LAMP";

             if(p_strWhere.Trim().Length > 0)
             {
                 strSql += " where " + p_strWhere;
             }

             DataTable dtTemp = new DataTable();
             DbHelper.GetTable(strSql, ref dtTemp);

             if(dtTemp.Rows.Count>0)
             {
                 if(dtTemp.Rows[0]["m"].ToString().Length>0)
                 {
                     strResult = dtTemp.Rows[0]["m"] == DBNull.Value ? "" : dtTemp.Rows[0]["m"].ToString();
                 }
             }

             dtTemp.Dispose();

             return string.Format("{0:D50}", Convert.ToInt32(strResult) + 1);

          }

          /// <summary>
          /// 得到最大JCLSH
          /// </summary>
          public string GetMax_JCLSH()
          {
              return GetMax_JCLSH("");
          }


          /// <summary>
          /// 判断数据是否存在
          /// </summary>
          public bool Exists(string strJCLSH)
          {
               bool bolResult = false;

               if (strJCLSH == null)
               {
                   return false;
               }

               if (strJCLSH.Length == 0)
               {
                   return false;
               }

               string strSql = "";
               strSql += "select count(1) as c from RESULT_LAMP";
               strSql += " where ";
               strSql += " JCLSH='"+ strJCLSH +"'";

               DataTable dtTemp = new DataTable();
               DbHelper.GetTable(strSql, ref dtTemp);

               if (dtTemp.Rows.Count > 0)
               {
                   bolResult = Convert.ToInt32(dtTemp.Rows[0]["c"]) > 0;
               }

               dtTemp.Dispose();

               return bolResult;

          }

          /// <summary>
          /// 获取数据总记录数
          /// </summary>
          public int GetRecordCount(string p_strWhere)
          {
              int intResult=0;

              string strSql = "";
              strSql += "select count(1) as c from RESULT_LAMP";
              if(p_strWhere.Trim().Length > 0)
              {
                 strSql += " where " + p_strWhere;
              }

              DataTable dtTemp = new DataTable();
              DbHelper.GetTable(strSql, ref dtTemp);

              if(dtTemp.Rows.Count>0)
              {
                  intResult=Convert.ToInt32(dtTemp.Rows[0]["c"]);
              }

              dtTemp.Dispose();

              return intResult;
          }

          /// <summary>
          /// 获取数据总记录数
          /// </summary>
          public int GetRecordCount()
          {
              return GetRecordCount("");
          }

          /// <summary>
          /// 获取数据分页总数
           /// </summary>
          public int GetPageCount(string p_strWhere, int p_intPageSize)
          {
              int intResult=0;

              if(p_intPageSize > 0)
              {
                  int intRecordCount = GetRecordCount(p_strWhere);
                  intResult = Convert.ToInt32(Math.Truncate(Convert.ToDecimal(intRecordCount) / Convert.ToDecimal(p_intPageSize)));
                  if (intRecordCount > (intResult * p_intPageSize))
                  {
                       intResult++;
                  }
              }

              if(intResult == 0)
              {
                   intResult++;
              }
              return intResult;
           }

          /// <summary>
          /// 获取数据分页总数
          /// </summary>
          public int GetPageCount(int p_intPageSize)
          {
              return GetPageCount("", p_intPageSize);
          }

          /// <summary>
          /// 添加一条数据 SQL
          /// </summary>
          public string InsertSQL(RESULT_LAMP model)
          {
              string strFieldSQL = "";
              string strValueSQL = "";

              if(model.Changed("ID") == true && model.ID != null)
              {
                   strFieldSQL += ",ID";
                   strValueSQL += "," + model.ID + "";
              }

              if(model.Changed("DGZWDJCCS") == true && model.DGZWDJCCS != null)
              {
                   strFieldSQL += ",DGZWDJCCS";
                   strValueSQL += ",'" + model.DGZWDJCCS.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("DGZNDJCCS") == true && model.DGZNDJCCS != null)
              {
                   strFieldSQL += ",DGZNDJCCS";
                   strValueSQL += ",'" + model.DGZNDJCCS.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("DGYNDJCCS") == true && model.DGYNDJCCS != null)
              {
                   strFieldSQL += ",DGYNDJCCS";
                   strValueSQL += ",'" + model.DGYNDJCCS.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("DGYWDJCCS") == true && model.DGYWDJCCS != null)
              {
                   strFieldSQL += ",DGYWDJCCS";
                   strValueSQL += ",'" + model.DGYWDJCCS.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("JCLSH") == true && model.JCLSH != null)
              {
                   strFieldSQL += ",JCLSH";
                   strValueSQL += ",'" + model.JCLSH.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDYGGQ") == true && model.ZWDYGGQ != null)
              {
                   strFieldSQL += ",ZWDYGGQ";
                   strValueSQL += ",'" + model.ZWDYGGQ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDYGGQ_PD") == true && model.ZWDYGGQ_PD != null)
              {
                   strFieldSQL += ",ZWDYGGQ_PD";
                   strValueSQL += ",'" + model.ZWDYGGQ_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDYGCZPYL") == true && model.ZWDYGCZPYL != null)
              {
                   strFieldSQL += ",ZWDYGCZPYL";
                   strValueSQL += ",'" + model.ZWDYGCZPYL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDYGSPPYL") == true && model.ZWDYGSPPYL != null)
              {
                   strFieldSQL += ",ZWDYGSPPYL";
                   strValueSQL += ",'" + model.ZWDYGSPPYL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDYGDG") == true && model.ZWDYGDG != null)
              {
                   strFieldSQL += ",ZWDYGDG";
                   strValueSQL += ",'" + model.ZWDYGDG.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDYGCZPY") == true && model.ZWDYGCZPY != null)
              {
                   strFieldSQL += ",ZWDYGCZPY";
                   strValueSQL += ",'" + model.ZWDYGCZPY.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDYGCZPY_PD") == true && model.ZWDYGCZPY_PD != null)
              {
                   strFieldSQL += ",ZWDYGCZPY_PD";
                   strValueSQL += ",'" + model.ZWDYGCZPY_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDYGSPPY") == true && model.ZWDYGSPPY != null)
              {
                   strFieldSQL += ",ZWDYGSPPY";
                   strValueSQL += ",'" + model.ZWDYGSPPY.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDYGSPPY_PD") == true && model.ZWDYGSPPY_PD != null)
              {
                   strFieldSQL += ",ZWDYGSPPY_PD";
                   strValueSQL += ",'" + model.ZWDYGSPPY_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDJGCZPYL") == true && model.ZWDJGCZPYL != null)
              {
                   strFieldSQL += ",ZWDJGCZPYL";
                   strValueSQL += ",'" + model.ZWDJGCZPYL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDJGSPPYL") == true && model.ZWDJGSPPYL != null)
              {
                   strFieldSQL += ",ZWDJGSPPYL";
                   strValueSQL += ",'" + model.ZWDJGSPPYL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDJGDG") == true && model.ZWDJGDG != null)
              {
                   strFieldSQL += ",ZWDJGDG";
                   strValueSQL += ",'" + model.ZWDJGDG.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDJGCZPY") == true && model.ZWDJGCZPY != null)
              {
                   strFieldSQL += ",ZWDJGCZPY";
                   strValueSQL += ",'" + model.ZWDJGCZPY.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDJGCZPY_PD") == true && model.ZWDJGCZPY_PD != null)
              {
                   strFieldSQL += ",ZWDJGCZPY_PD";
                   strValueSQL += ",'" + model.ZWDJGCZPY_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDJGSPPY") == true && model.ZWDJGSPPY != null)
              {
                   strFieldSQL += ",ZWDJGSPPY";
                   strValueSQL += ",'" + model.ZWDJGSPPY.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDJGSPPY_PD") == true && model.ZWDJGSPPY_PD != null)
              {
                   strFieldSQL += ",ZWDJGSPPY_PD";
                   strValueSQL += ",'" + model.ZWDJGSPPY_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDZ_PD") == true && model.ZWDZ_PD != null)
              {
                   strFieldSQL += ",ZWDZ_PD";
                   strValueSQL += ",'" + model.ZWDZ_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDYGGQ") == true && model.ZNDYGGQ != null)
              {
                   strFieldSQL += ",ZNDYGGQ";
                   strValueSQL += ",'" + model.ZNDYGGQ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDYGGQ_PD") == true && model.ZNDYGGQ_PD != null)
              {
                   strFieldSQL += ",ZNDYGGQ_PD";
                   strValueSQL += ",'" + model.ZNDYGGQ_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDYGCZPYL") == true && model.ZNDYGCZPYL != null)
              {
                   strFieldSQL += ",ZNDYGCZPYL";
                   strValueSQL += ",'" + model.ZNDYGCZPYL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDYGSPPYL") == true && model.ZNDYGSPPYL != null)
              {
                   strFieldSQL += ",ZNDYGSPPYL";
                   strValueSQL += ",'" + model.ZNDYGSPPYL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDYGDG") == true && model.ZNDYGDG != null)
              {
                   strFieldSQL += ",ZNDYGDG";
                   strValueSQL += ",'" + model.ZNDYGDG.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDYGCZPY") == true && model.ZNDYGCZPY != null)
              {
                   strFieldSQL += ",ZNDYGCZPY";
                   strValueSQL += ",'" + model.ZNDYGCZPY.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDYGCZPY_PD") == true && model.ZNDYGCZPY_PD != null)
              {
                   strFieldSQL += ",ZNDYGCZPY_PD";
                   strValueSQL += ",'" + model.ZNDYGCZPY_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDYGSPPY") == true && model.ZNDYGSPPY != null)
              {
                   strFieldSQL += ",ZNDYGSPPY";
                   strValueSQL += ",'" + model.ZNDYGSPPY.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDYGSPPY_PD") == true && model.ZNDYGSPPY_PD != null)
              {
                   strFieldSQL += ",ZNDYGSPPY_PD";
                   strValueSQL += ",'" + model.ZNDYGSPPY_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDJGCZPYL") == true && model.ZNDJGCZPYL != null)
              {
                   strFieldSQL += ",ZNDJGCZPYL";
                   strValueSQL += ",'" + model.ZNDJGCZPYL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDJGSPPYL") == true && model.ZNDJGSPPYL != null)
              {
                   strFieldSQL += ",ZNDJGSPPYL";
                   strValueSQL += ",'" + model.ZNDJGSPPYL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDJGDG") == true && model.ZNDJGDG != null)
              {
                   strFieldSQL += ",ZNDJGDG";
                   strValueSQL += ",'" + model.ZNDJGDG.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDJGCZPY") == true && model.ZNDJGCZPY != null)
              {
                   strFieldSQL += ",ZNDJGCZPY";
                   strValueSQL += ",'" + model.ZNDJGCZPY.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDJGCZPY_PD") == true && model.ZNDJGCZPY_PD != null)
              {
                   strFieldSQL += ",ZNDJGCZPY_PD";
                   strValueSQL += ",'" + model.ZNDJGCZPY_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDJGSPPY") == true && model.ZNDJGSPPY != null)
              {
                   strFieldSQL += ",ZNDJGSPPY";
                   strValueSQL += ",'" + model.ZNDJGSPPY.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDJGSPPY_PD") == true && model.ZNDJGSPPY_PD != null)
              {
                   strFieldSQL += ",ZNDJGSPPY_PD";
                   strValueSQL += ",'" + model.ZNDJGSPPY_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDZ_PD") == true && model.ZNDZ_PD != null)
              {
                   strFieldSQL += ",ZNDZ_PD";
                   strValueSQL += ",'" + model.ZNDZ_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDYGGQ") == true && model.YNDYGGQ != null)
              {
                   strFieldSQL += ",YNDYGGQ";
                   strValueSQL += ",'" + model.YNDYGGQ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDYGGQ_PD") == true && model.YNDYGGQ_PD != null)
              {
                   strFieldSQL += ",YNDYGGQ_PD";
                   strValueSQL += ",'" + model.YNDYGGQ_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDYGCZPYL") == true && model.YNDYGCZPYL != null)
              {
                   strFieldSQL += ",YNDYGCZPYL";
                   strValueSQL += ",'" + model.YNDYGCZPYL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDYGSPPYL") == true && model.YNDYGSPPYL != null)
              {
                   strFieldSQL += ",YNDYGSPPYL";
                   strValueSQL += ",'" + model.YNDYGSPPYL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDYGDG") == true && model.YNDYGDG != null)
              {
                   strFieldSQL += ",YNDYGDG";
                   strValueSQL += ",'" + model.YNDYGDG.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDYGCZPY") == true && model.YNDYGCZPY != null)
              {
                   strFieldSQL += ",YNDYGCZPY";
                   strValueSQL += ",'" + model.YNDYGCZPY.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDYGCZPY_PD") == true && model.YNDYGCZPY_PD != null)
              {
                   strFieldSQL += ",YNDYGCZPY_PD";
                   strValueSQL += ",'" + model.YNDYGCZPY_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDYGSPPY") == true && model.YNDYGSPPY != null)
              {
                   strFieldSQL += ",YNDYGSPPY";
                   strValueSQL += ",'" + model.YNDYGSPPY.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDYGSPPY_PD") == true && model.YNDYGSPPY_PD != null)
              {
                   strFieldSQL += ",YNDYGSPPY_PD";
                   strValueSQL += ",'" + model.YNDYGSPPY_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDJGCZPYL") == true && model.YNDJGCZPYL != null)
              {
                   strFieldSQL += ",YNDJGCZPYL";
                   strValueSQL += ",'" + model.YNDJGCZPYL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDJGSPPYL") == true && model.YNDJGSPPYL != null)
              {
                   strFieldSQL += ",YNDJGSPPYL";
                   strValueSQL += ",'" + model.YNDJGSPPYL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDJGDG") == true && model.YNDJGDG != null)
              {
                   strFieldSQL += ",YNDJGDG";
                   strValueSQL += ",'" + model.YNDJGDG.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDJGCZPY") == true && model.YNDJGCZPY != null)
              {
                   strFieldSQL += ",YNDJGCZPY";
                   strValueSQL += ",'" + model.YNDJGCZPY.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDJGCZPY_PD") == true && model.YNDJGCZPY_PD != null)
              {
                   strFieldSQL += ",YNDJGCZPY_PD";
                   strValueSQL += ",'" + model.YNDJGCZPY_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDJGSPPY") == true && model.YNDJGSPPY != null)
              {
                   strFieldSQL += ",YNDJGSPPY";
                   strValueSQL += ",'" + model.YNDJGSPPY.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDJGSPPY_PD") == true && model.YNDJGSPPY_PD != null)
              {
                   strFieldSQL += ",YNDJGSPPY_PD";
                   strValueSQL += ",'" + model.YNDJGSPPY_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDZ_PD") == true && model.YNDZ_PD != null)
              {
                   strFieldSQL += ",YNDZ_PD";
                   strValueSQL += ",'" + model.YNDZ_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDYGGQ") == true && model.YWDYGGQ != null)
              {
                   strFieldSQL += ",YWDYGGQ";
                   strValueSQL += ",'" + model.YWDYGGQ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDYGGQ_PD") == true && model.YWDYGGQ_PD != null)
              {
                   strFieldSQL += ",YWDYGGQ_PD";
                   strValueSQL += ",'" + model.YWDYGGQ_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDYGCZPYL") == true && model.YWDYGCZPYL != null)
              {
                   strFieldSQL += ",YWDYGCZPYL";
                   strValueSQL += ",'" + model.YWDYGCZPYL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDYGSPPYL") == true && model.YWDYGSPPYL != null)
              {
                   strFieldSQL += ",YWDYGSPPYL";
                   strValueSQL += ",'" + model.YWDYGSPPYL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDYGDG") == true && model.YWDYGDG != null)
              {
                   strFieldSQL += ",YWDYGDG";
                   strValueSQL += ",'" + model.YWDYGDG.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDYGCZPY") == true && model.YWDYGCZPY != null)
              {
                   strFieldSQL += ",YWDYGCZPY";
                   strValueSQL += ",'" + model.YWDYGCZPY.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDYGCZPY_PD") == true && model.YWDYGCZPY_PD != null)
              {
                   strFieldSQL += ",YWDYGCZPY_PD";
                   strValueSQL += ",'" + model.YWDYGCZPY_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDYGSPPY") == true && model.YWDYGSPPY != null)
              {
                   strFieldSQL += ",YWDYGSPPY";
                   strValueSQL += ",'" + model.YWDYGSPPY.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDYGSPPY_PD") == true && model.YWDYGSPPY_PD != null)
              {
                   strFieldSQL += ",YWDYGSPPY_PD";
                   strValueSQL += ",'" + model.YWDYGSPPY_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDJGCZPYL") == true && model.YWDJGCZPYL != null)
              {
                   strFieldSQL += ",YWDJGCZPYL";
                   strValueSQL += ",'" + model.YWDJGCZPYL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDJGSPPYL") == true && model.YWDJGSPPYL != null)
              {
                   strFieldSQL += ",YWDJGSPPYL";
                   strValueSQL += ",'" + model.YWDJGSPPYL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDJGDG") == true && model.YWDJGDG != null)
              {
                   strFieldSQL += ",YWDJGDG";
                   strValueSQL += ",'" + model.YWDJGDG.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDJGCZPY") == true && model.YWDJGCZPY != null)
              {
                   strFieldSQL += ",YWDJGCZPY";
                   strValueSQL += ",'" + model.YWDJGCZPY.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDJGCZPY_PD") == true && model.YWDJGCZPY_PD != null)
              {
                   strFieldSQL += ",YWDJGCZPY_PD";
                   strValueSQL += ",'" + model.YWDJGCZPY_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDJGSPPY") == true && model.YWDJGSPPY != null)
              {
                   strFieldSQL += ",YWDJGSPPY";
                   strValueSQL += ",'" + model.YWDJGSPPY.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDJGSPPY_PD") == true && model.YWDJGSPPY_PD != null)
              {
                   strFieldSQL += ",YWDJGSPPY_PD";
                   strValueSQL += ",'" + model.YWDJGSPPY_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDZ_PD") == true && model.YWDZ_PD != null)
              {
                   strFieldSQL += ",YWDZ_PD";
                   strValueSQL += ",'" + model.YWDZ_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("DGZGQ") == true && model.DGZGQ != null)
              {
                   strFieldSQL += ",DGZGQ";
                   strValueSQL += ",'" + model.DGZGQ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("DGZGQ_PD") == true && model.DGZGQ_PD != null)
              {
                   strFieldSQL += ",DGZGQ_PD";
                   strValueSQL += ",'" + model.DGZGQ_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("DGGQXZ") == true && model.DGGQXZ != null)
              {
                   strFieldSQL += ",DGGQXZ";
                   strValueSQL += ",'" + model.DGGQXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YGCZPYXZXX") == true && model.YGCZPYXZXX != null)
              {
                   strFieldSQL += ",YGCZPYXZXX";
                   strValueSQL += ",'" + model.YGCZPYXZXX.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YGCZPYXZSX") == true && model.YGCZPYXZSX != null)
              {
                   strFieldSQL += ",YGCZPYXZSX";
                   strValueSQL += ",'" + model.YGCZPYXZSX.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YGZDZPXZ") == true && model.YGZDZPXZ != null)
              {
                   strFieldSQL += ",YGZDZPXZ";
                   strValueSQL += ",'" + model.YGZDZPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YGZDYPXZ") == true && model.YGZDYPXZ != null)
              {
                   strFieldSQL += ",YGZDYPXZ";
                   strValueSQL += ",'" + model.YGZDYPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YGYDZPXZ") == true && model.YGYDZPXZ != null)
              {
                   strFieldSQL += ",YGYDZPXZ";
                   strValueSQL += ",'" + model.YGYDZPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YGYDYPXZ") == true && model.YGYDYPXZ != null)
              {
                   strFieldSQL += ",YGYDYPXZ";
                   strValueSQL += ",'" + model.YGYDYPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("JGCZPYXZXX") == true && model.JGCZPYXZXX != null)
              {
                   strFieldSQL += ",JGCZPYXZXX";
                   strValueSQL += ",'" + model.JGCZPYXZXX.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("JGCZPYXZSX") == true && model.JGCZPYXZSX != null)
              {
                   strFieldSQL += ",JGCZPYXZSX";
                   strValueSQL += ",'" + model.JGCZPYXZSX.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("JGZDZPXZ") == true && model.JGZDZPXZ != null)
              {
                   strFieldSQL += ",JGZDZPXZ";
                   strValueSQL += ",'" + model.JGZDZPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("JGZDYPXZ") == true && model.JGZDYPXZ != null)
              {
                   strFieldSQL += ",JGZDYPXZ";
                   strValueSQL += ",'" + model.JGZDYPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("JGYDZPXZ") == true && model.JGYDZPXZ != null)
              {
                   strFieldSQL += ",JGYDZPXZ";
                   strValueSQL += ",'" + model.JGYDZPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("JGYDYPXZ") == true && model.JGYDYPXZ != null)
              {
                   strFieldSQL += ",JGYDYPXZ";
                   strValueSQL += ",'" + model.JGYDYPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZGQXZ") == true && model.ZGQXZ != null)
              {
                   strFieldSQL += ",ZGQXZ";
                   strValueSQL += ",'" + model.ZGQXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("DGZ_PD") == true && model.DGZ_PD != null)
              {
                   strFieldSQL += ",DGZ_PD";
                   strValueSQL += ",'" + model.DGZ_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("KSSJ") == true && model.KSSJ != null)
              {
                   strFieldSQL += ",KSSJ";
                   strValueSQL += ",'" + model.KSSJ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("JSSJ") == true && model.JSSJ != null)
              {
                   strFieldSQL += ",JSSJ";
                   strValueSQL += ",'" + model.JSSJ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("BIG1000JGCZPYXZXX") == true && model.BIG1000JGCZPYXZXX != null)
              {
                   strFieldSQL += ",BIG1000JGCZPYXZXX";
                   strValueSQL += ",'" + model.BIG1000JGCZPYXZXX.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("BIG1000JGCZPYXZSX") == true && model.BIG1000JGCZPYXZSX != null)
              {
                   strFieldSQL += ",BIG1000JGCZPYXZSX";
                   strValueSQL += ",'" + model.BIG1000JGCZPYXZSX.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDDGGQXZ") == true && model.ZWDDGGQXZ != null)
              {
                   strFieldSQL += ",ZWDDGGQXZ";
                   strValueSQL += ",'" + model.ZWDDGGQXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDYGCZPYXZSX") == true && model.ZWDYGCZPYXZSX != null)
              {
                   strFieldSQL += ",ZWDYGCZPYXZSX";
                   strValueSQL += ",'" + model.ZWDYGCZPYXZSX.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDYGCZPYXZXX") == true && model.ZWDYGCZPYXZXX != null)
              {
                   strFieldSQL += ",ZWDYGCZPYXZXX";
                   strValueSQL += ",'" + model.ZWDYGCZPYXZXX.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDJGCZPYXZSX") == true && model.ZWDJGCZPYXZSX != null)
              {
                   strFieldSQL += ",ZWDJGCZPYXZSX";
                   strValueSQL += ",'" + model.ZWDJGCZPYXZSX.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDJGCZPYXZXX") == true && model.ZWDJGCZPYXZXX != null)
              {
                   strFieldSQL += ",ZWDJGCZPYXZXX";
                   strValueSQL += ",'" + model.ZWDJGCZPYXZXX.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDYGZDYPXZ") == true && model.ZWDYGZDYPXZ != null)
              {
                   strFieldSQL += ",ZWDYGZDYPXZ";
                   strValueSQL += ",'" + model.ZWDYGZDYPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDYGZDZPXZ") == true && model.ZWDYGZDZPXZ != null)
              {
                   strFieldSQL += ",ZWDYGZDZPXZ";
                   strValueSQL += ",'" + model.ZWDYGZDZPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDYGYDYPXZ") == true && model.ZWDYGYDYPXZ != null)
              {
                   strFieldSQL += ",ZWDYGYDYPXZ";
                   strValueSQL += ",'" + model.ZWDYGYDYPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDYGYDZPXZ") == true && model.ZWDYGYDZPXZ != null)
              {
                   strFieldSQL += ",ZWDYGYDZPXZ";
                   strValueSQL += ",'" + model.ZWDYGYDZPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDJGZDYPXZ") == true && model.ZWDJGZDYPXZ != null)
              {
                   strFieldSQL += ",ZWDJGZDYPXZ";
                   strValueSQL += ",'" + model.ZWDJGZDYPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDJGZDZPXZ") == true && model.ZWDJGZDZPXZ != null)
              {
                   strFieldSQL += ",ZWDJGZDZPXZ";
                   strValueSQL += ",'" + model.ZWDJGZDZPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDJGYDYPXZ") == true && model.ZWDJGYDYPXZ != null)
              {
                   strFieldSQL += ",ZWDJGYDYPXZ";
                   strValueSQL += ",'" + model.ZWDJGYDYPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDJGYDZPXZ") == true && model.ZWDJGYDZPXZ != null)
              {
                   strFieldSQL += ",ZWDJGYDZPXZ";
                   strValueSQL += ",'" + model.ZWDJGYDZPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDDGGQXZ") == true && model.ZNDDGGQXZ != null)
              {
                   strFieldSQL += ",ZNDDGGQXZ";
                   strValueSQL += ",'" + model.ZNDDGGQXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDYGCZPYXZSX") == true && model.ZNDYGCZPYXZSX != null)
              {
                   strFieldSQL += ",ZNDYGCZPYXZSX";
                   strValueSQL += ",'" + model.ZNDYGCZPYXZSX.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDYGCZPYXZXX") == true && model.ZNDYGCZPYXZXX != null)
              {
                   strFieldSQL += ",ZNDYGCZPYXZXX";
                   strValueSQL += ",'" + model.ZNDYGCZPYXZXX.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDJGCZPYXZSX") == true && model.ZNDJGCZPYXZSX != null)
              {
                   strFieldSQL += ",ZNDJGCZPYXZSX";
                   strValueSQL += ",'" + model.ZNDJGCZPYXZSX.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDJGCZPYXZXX") == true && model.ZNDJGCZPYXZXX != null)
              {
                   strFieldSQL += ",ZNDJGCZPYXZXX";
                   strValueSQL += ",'" + model.ZNDJGCZPYXZXX.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDYGZDYPXZ") == true && model.ZNDYGZDYPXZ != null)
              {
                   strFieldSQL += ",ZNDYGZDYPXZ";
                   strValueSQL += ",'" + model.ZNDYGZDYPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDYGZDZPXZ") == true && model.ZNDYGZDZPXZ != null)
              {
                   strFieldSQL += ",ZNDYGZDZPXZ";
                   strValueSQL += ",'" + model.ZNDYGZDZPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDYGYDYPXZ") == true && model.ZNDYGYDYPXZ != null)
              {
                   strFieldSQL += ",ZNDYGYDYPXZ";
                   strValueSQL += ",'" + model.ZNDYGYDYPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDYGYDZPXZ") == true && model.ZNDYGYDZPXZ != null)
              {
                   strFieldSQL += ",ZNDYGYDZPXZ";
                   strValueSQL += ",'" + model.ZNDYGYDZPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDJGZDYPXZ") == true && model.ZNDJGZDYPXZ != null)
              {
                   strFieldSQL += ",ZNDJGZDYPXZ";
                   strValueSQL += ",'" + model.ZNDJGZDYPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDJGZDZPXZ") == true && model.ZNDJGZDZPXZ != null)
              {
                   strFieldSQL += ",ZNDJGZDZPXZ";
                   strValueSQL += ",'" + model.ZNDJGZDZPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDJGYDYPXZ") == true && model.ZNDJGYDYPXZ != null)
              {
                   strFieldSQL += ",ZNDJGYDYPXZ";
                   strValueSQL += ",'" + model.ZNDJGYDYPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDJGYDZPXZ") == true && model.ZNDJGYDZPXZ != null)
              {
                   strFieldSQL += ",ZNDJGYDZPXZ";
                   strValueSQL += ",'" + model.ZNDJGYDZPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDDGGQXZ") == true && model.YNDDGGQXZ != null)
              {
                   strFieldSQL += ",YNDDGGQXZ";
                   strValueSQL += ",'" + model.YNDDGGQXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDYGCZPYXZSX") == true && model.YNDYGCZPYXZSX != null)
              {
                   strFieldSQL += ",YNDYGCZPYXZSX";
                   strValueSQL += ",'" + model.YNDYGCZPYXZSX.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDYGCZPYXZXX") == true && model.YNDYGCZPYXZXX != null)
              {
                   strFieldSQL += ",YNDYGCZPYXZXX";
                   strValueSQL += ",'" + model.YNDYGCZPYXZXX.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDJGCZPYXZSX") == true && model.YNDJGCZPYXZSX != null)
              {
                   strFieldSQL += ",YNDJGCZPYXZSX";
                   strValueSQL += ",'" + model.YNDJGCZPYXZSX.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDJGCZPYXZXX") == true && model.YNDJGCZPYXZXX != null)
              {
                   strFieldSQL += ",YNDJGCZPYXZXX";
                   strValueSQL += ",'" + model.YNDJGCZPYXZXX.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDYGZDYPXZ") == true && model.YNDYGZDYPXZ != null)
              {
                   strFieldSQL += ",YNDYGZDYPXZ";
                   strValueSQL += ",'" + model.YNDYGZDYPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDYGZDZPXZ") == true && model.YNDYGZDZPXZ != null)
              {
                   strFieldSQL += ",YNDYGZDZPXZ";
                   strValueSQL += ",'" + model.YNDYGZDZPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDYGYDYPXZ") == true && model.YNDYGYDYPXZ != null)
              {
                   strFieldSQL += ",YNDYGYDYPXZ";
                   strValueSQL += ",'" + model.YNDYGYDYPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDYGYDZPXZ") == true && model.YNDYGYDZPXZ != null)
              {
                   strFieldSQL += ",YNDYGYDZPXZ";
                   strValueSQL += ",'" + model.YNDYGYDZPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDJGZDYPXZ") == true && model.YNDJGZDYPXZ != null)
              {
                   strFieldSQL += ",YNDJGZDYPXZ";
                   strValueSQL += ",'" + model.YNDJGZDYPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDJGZDZPXZ") == true && model.YNDJGZDZPXZ != null)
              {
                   strFieldSQL += ",YNDJGZDZPXZ";
                   strValueSQL += ",'" + model.YNDJGZDZPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDJGYDYPXZ") == true && model.YNDJGYDYPXZ != null)
              {
                   strFieldSQL += ",YNDJGYDYPXZ";
                   strValueSQL += ",'" + model.YNDJGYDYPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDJGYDZPXZ") == true && model.YNDJGYDZPXZ != null)
              {
                   strFieldSQL += ",YNDJGYDZPXZ";
                   strValueSQL += ",'" + model.YNDJGYDZPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDDGGQXZ") == true && model.YWDDGGQXZ != null)
              {
                   strFieldSQL += ",YWDDGGQXZ";
                   strValueSQL += ",'" + model.YWDDGGQXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDYGCZPYXZSX") == true && model.YWDYGCZPYXZSX != null)
              {
                   strFieldSQL += ",YWDYGCZPYXZSX";
                   strValueSQL += ",'" + model.YWDYGCZPYXZSX.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDYGCZPYXZXX") == true && model.YWDYGCZPYXZXX != null)
              {
                   strFieldSQL += ",YWDYGCZPYXZXX";
                   strValueSQL += ",'" + model.YWDYGCZPYXZXX.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDJGCZPYXZSX") == true && model.YWDJGCZPYXZSX != null)
              {
                   strFieldSQL += ",YWDJGCZPYXZSX";
                   strValueSQL += ",'" + model.YWDJGCZPYXZSX.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDJGCZPYXZXX") == true && model.YWDJGCZPYXZXX != null)
              {
                   strFieldSQL += ",YWDJGCZPYXZXX";
                   strValueSQL += ",'" + model.YWDJGCZPYXZXX.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDYGZDYPXZ") == true && model.YWDYGZDYPXZ != null)
              {
                   strFieldSQL += ",YWDYGZDYPXZ";
                   strValueSQL += ",'" + model.YWDYGZDYPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDYGZDZPXZ") == true && model.YWDYGZDZPXZ != null)
              {
                   strFieldSQL += ",YWDYGZDZPXZ";
                   strValueSQL += ",'" + model.YWDYGZDZPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDYGYDYPXZ") == true && model.YWDYGYDYPXZ != null)
              {
                   strFieldSQL += ",YWDYGYDYPXZ";
                   strValueSQL += ",'" + model.YWDYGYDYPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDYGYDZPXZ") == true && model.YWDYGYDZPXZ != null)
              {
                   strFieldSQL += ",YWDYGYDZPXZ";
                   strValueSQL += ",'" + model.YWDYGYDZPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDJGZDYPXZ") == true && model.YWDJGZDYPXZ != null)
              {
                   strFieldSQL += ",YWDJGZDYPXZ";
                   strValueSQL += ",'" + model.YWDJGZDYPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDJGZDZPXZ") == true && model.YWDJGZDZPXZ != null)
              {
                   strFieldSQL += ",YWDJGZDZPXZ";
                   strValueSQL += ",'" + model.YWDJGZDZPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDJGYDYPXZ") == true && model.YWDJGYDYPXZ != null)
              {
                   strFieldSQL += ",YWDJGYDYPXZ";
                   strValueSQL += ",'" + model.YWDJGYDYPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDJGYDZPXZ") == true && model.YWDJGYDZPXZ != null)
              {
                   strFieldSQL += ",YWDJGYDZPXZ";
                   strValueSQL += ",'" + model.YWDJGYDZPXZ.ToString().Replace("'","''") + "'";
              }

              string strSql = "";
              strSql += "insert into RESULT_LAMP";
              strSql += "(";
              strSql += strFieldSQL.Substring(1);
              strSql += ")";
              strSql += " values";
              strSql += "(";
              strSql += strValueSQL.Substring(1);
              strSql += ")";

              return strSql;
          }

          /// <summary>
          /// 添加一条数据
          /// </summary>
          public bool Insert(RESULT_LAMP model)
          {
              return DbHelper.ExecuteSql(InsertSQL(model));
          }

          /// <summary>
          /// 修改一条数据 SQL
          /// </summary>
          public string UpdateSQL(RESULT_LAMP model,string strJCLSH)
          {
              string strUpdateSQL = "";

              if(model.Changed("ID") == true && model.ID != null)
              {
                  strUpdateSQL += ",ID=" + model.ID + "";
              }

              if(model.Changed("DGZWDJCCS") == true && model.DGZWDJCCS != null)
              {
                  strUpdateSQL += ",DGZWDJCCS='" + model.DGZWDJCCS.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("DGZNDJCCS") == true && model.DGZNDJCCS != null)
              {
                  strUpdateSQL += ",DGZNDJCCS='" + model.DGZNDJCCS.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("DGYNDJCCS") == true && model.DGYNDJCCS != null)
              {
                  strUpdateSQL += ",DGYNDJCCS='" + model.DGYNDJCCS.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("DGYWDJCCS") == true && model.DGYWDJCCS != null)
              {
                  strUpdateSQL += ",DGYWDJCCS='" + model.DGYWDJCCS.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("JCLSH") == true && model.JCLSH != null)
              {
                  strUpdateSQL += ",JCLSH='" + model.JCLSH.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDYGGQ") == true && model.ZWDYGGQ != null)
              {
                  strUpdateSQL += ",ZWDYGGQ='" + model.ZWDYGGQ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDYGGQ_PD") == true && model.ZWDYGGQ_PD != null)
              {
                  strUpdateSQL += ",ZWDYGGQ_PD='" + model.ZWDYGGQ_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDYGCZPYL") == true && model.ZWDYGCZPYL != null)
              {
                  strUpdateSQL += ",ZWDYGCZPYL='" + model.ZWDYGCZPYL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDYGSPPYL") == true && model.ZWDYGSPPYL != null)
              {
                  strUpdateSQL += ",ZWDYGSPPYL='" + model.ZWDYGSPPYL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDYGDG") == true && model.ZWDYGDG != null)
              {
                  strUpdateSQL += ",ZWDYGDG='" + model.ZWDYGDG.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDYGCZPY") == true && model.ZWDYGCZPY != null)
              {
                  strUpdateSQL += ",ZWDYGCZPY='" + model.ZWDYGCZPY.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDYGCZPY_PD") == true && model.ZWDYGCZPY_PD != null)
              {
                  strUpdateSQL += ",ZWDYGCZPY_PD='" + model.ZWDYGCZPY_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDYGSPPY") == true && model.ZWDYGSPPY != null)
              {
                  strUpdateSQL += ",ZWDYGSPPY='" + model.ZWDYGSPPY.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDYGSPPY_PD") == true && model.ZWDYGSPPY_PD != null)
              {
                  strUpdateSQL += ",ZWDYGSPPY_PD='" + model.ZWDYGSPPY_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDJGCZPYL") == true && model.ZWDJGCZPYL != null)
              {
                  strUpdateSQL += ",ZWDJGCZPYL='" + model.ZWDJGCZPYL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDJGSPPYL") == true && model.ZWDJGSPPYL != null)
              {
                  strUpdateSQL += ",ZWDJGSPPYL='" + model.ZWDJGSPPYL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDJGDG") == true && model.ZWDJGDG != null)
              {
                  strUpdateSQL += ",ZWDJGDG='" + model.ZWDJGDG.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDJGCZPY") == true && model.ZWDJGCZPY != null)
              {
                  strUpdateSQL += ",ZWDJGCZPY='" + model.ZWDJGCZPY.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDJGCZPY_PD") == true && model.ZWDJGCZPY_PD != null)
              {
                  strUpdateSQL += ",ZWDJGCZPY_PD='" + model.ZWDJGCZPY_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDJGSPPY") == true && model.ZWDJGSPPY != null)
              {
                  strUpdateSQL += ",ZWDJGSPPY='" + model.ZWDJGSPPY.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDJGSPPY_PD") == true && model.ZWDJGSPPY_PD != null)
              {
                  strUpdateSQL += ",ZWDJGSPPY_PD='" + model.ZWDJGSPPY_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDZ_PD") == true && model.ZWDZ_PD != null)
              {
                  strUpdateSQL += ",ZWDZ_PD='" + model.ZWDZ_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDYGGQ") == true && model.ZNDYGGQ != null)
              {
                  strUpdateSQL += ",ZNDYGGQ='" + model.ZNDYGGQ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDYGGQ_PD") == true && model.ZNDYGGQ_PD != null)
              {
                  strUpdateSQL += ",ZNDYGGQ_PD='" + model.ZNDYGGQ_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDYGCZPYL") == true && model.ZNDYGCZPYL != null)
              {
                  strUpdateSQL += ",ZNDYGCZPYL='" + model.ZNDYGCZPYL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDYGSPPYL") == true && model.ZNDYGSPPYL != null)
              {
                  strUpdateSQL += ",ZNDYGSPPYL='" + model.ZNDYGSPPYL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDYGDG") == true && model.ZNDYGDG != null)
              {
                  strUpdateSQL += ",ZNDYGDG='" + model.ZNDYGDG.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDYGCZPY") == true && model.ZNDYGCZPY != null)
              {
                  strUpdateSQL += ",ZNDYGCZPY='" + model.ZNDYGCZPY.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDYGCZPY_PD") == true && model.ZNDYGCZPY_PD != null)
              {
                  strUpdateSQL += ",ZNDYGCZPY_PD='" + model.ZNDYGCZPY_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDYGSPPY") == true && model.ZNDYGSPPY != null)
              {
                  strUpdateSQL += ",ZNDYGSPPY='" + model.ZNDYGSPPY.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDYGSPPY_PD") == true && model.ZNDYGSPPY_PD != null)
              {
                  strUpdateSQL += ",ZNDYGSPPY_PD='" + model.ZNDYGSPPY_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDJGCZPYL") == true && model.ZNDJGCZPYL != null)
              {
                  strUpdateSQL += ",ZNDJGCZPYL='" + model.ZNDJGCZPYL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDJGSPPYL") == true && model.ZNDJGSPPYL != null)
              {
                  strUpdateSQL += ",ZNDJGSPPYL='" + model.ZNDJGSPPYL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDJGDG") == true && model.ZNDJGDG != null)
              {
                  strUpdateSQL += ",ZNDJGDG='" + model.ZNDJGDG.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDJGCZPY") == true && model.ZNDJGCZPY != null)
              {
                  strUpdateSQL += ",ZNDJGCZPY='" + model.ZNDJGCZPY.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDJGCZPY_PD") == true && model.ZNDJGCZPY_PD != null)
              {
                  strUpdateSQL += ",ZNDJGCZPY_PD='" + model.ZNDJGCZPY_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDJGSPPY") == true && model.ZNDJGSPPY != null)
              {
                  strUpdateSQL += ",ZNDJGSPPY='" + model.ZNDJGSPPY.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDJGSPPY_PD") == true && model.ZNDJGSPPY_PD != null)
              {
                  strUpdateSQL += ",ZNDJGSPPY_PD='" + model.ZNDJGSPPY_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDZ_PD") == true && model.ZNDZ_PD != null)
              {
                  strUpdateSQL += ",ZNDZ_PD='" + model.ZNDZ_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDYGGQ") == true && model.YNDYGGQ != null)
              {
                  strUpdateSQL += ",YNDYGGQ='" + model.YNDYGGQ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDYGGQ_PD") == true && model.YNDYGGQ_PD != null)
              {
                  strUpdateSQL += ",YNDYGGQ_PD='" + model.YNDYGGQ_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDYGCZPYL") == true && model.YNDYGCZPYL != null)
              {
                  strUpdateSQL += ",YNDYGCZPYL='" + model.YNDYGCZPYL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDYGSPPYL") == true && model.YNDYGSPPYL != null)
              {
                  strUpdateSQL += ",YNDYGSPPYL='" + model.YNDYGSPPYL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDYGDG") == true && model.YNDYGDG != null)
              {
                  strUpdateSQL += ",YNDYGDG='" + model.YNDYGDG.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDYGCZPY") == true && model.YNDYGCZPY != null)
              {
                  strUpdateSQL += ",YNDYGCZPY='" + model.YNDYGCZPY.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDYGCZPY_PD") == true && model.YNDYGCZPY_PD != null)
              {
                  strUpdateSQL += ",YNDYGCZPY_PD='" + model.YNDYGCZPY_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDYGSPPY") == true && model.YNDYGSPPY != null)
              {
                  strUpdateSQL += ",YNDYGSPPY='" + model.YNDYGSPPY.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDYGSPPY_PD") == true && model.YNDYGSPPY_PD != null)
              {
                  strUpdateSQL += ",YNDYGSPPY_PD='" + model.YNDYGSPPY_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDJGCZPYL") == true && model.YNDJGCZPYL != null)
              {
                  strUpdateSQL += ",YNDJGCZPYL='" + model.YNDJGCZPYL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDJGSPPYL") == true && model.YNDJGSPPYL != null)
              {
                  strUpdateSQL += ",YNDJGSPPYL='" + model.YNDJGSPPYL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDJGDG") == true && model.YNDJGDG != null)
              {
                  strUpdateSQL += ",YNDJGDG='" + model.YNDJGDG.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDJGCZPY") == true && model.YNDJGCZPY != null)
              {
                  strUpdateSQL += ",YNDJGCZPY='" + model.YNDJGCZPY.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDJGCZPY_PD") == true && model.YNDJGCZPY_PD != null)
              {
                  strUpdateSQL += ",YNDJGCZPY_PD='" + model.YNDJGCZPY_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDJGSPPY") == true && model.YNDJGSPPY != null)
              {
                  strUpdateSQL += ",YNDJGSPPY='" + model.YNDJGSPPY.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDJGSPPY_PD") == true && model.YNDJGSPPY_PD != null)
              {
                  strUpdateSQL += ",YNDJGSPPY_PD='" + model.YNDJGSPPY_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDZ_PD") == true && model.YNDZ_PD != null)
              {
                  strUpdateSQL += ",YNDZ_PD='" + model.YNDZ_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDYGGQ") == true && model.YWDYGGQ != null)
              {
                  strUpdateSQL += ",YWDYGGQ='" + model.YWDYGGQ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDYGGQ_PD") == true && model.YWDYGGQ_PD != null)
              {
                  strUpdateSQL += ",YWDYGGQ_PD='" + model.YWDYGGQ_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDYGCZPYL") == true && model.YWDYGCZPYL != null)
              {
                  strUpdateSQL += ",YWDYGCZPYL='" + model.YWDYGCZPYL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDYGSPPYL") == true && model.YWDYGSPPYL != null)
              {
                  strUpdateSQL += ",YWDYGSPPYL='" + model.YWDYGSPPYL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDYGDG") == true && model.YWDYGDG != null)
              {
                  strUpdateSQL += ",YWDYGDG='" + model.YWDYGDG.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDYGCZPY") == true && model.YWDYGCZPY != null)
              {
                  strUpdateSQL += ",YWDYGCZPY='" + model.YWDYGCZPY.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDYGCZPY_PD") == true && model.YWDYGCZPY_PD != null)
              {
                  strUpdateSQL += ",YWDYGCZPY_PD='" + model.YWDYGCZPY_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDYGSPPY") == true && model.YWDYGSPPY != null)
              {
                  strUpdateSQL += ",YWDYGSPPY='" + model.YWDYGSPPY.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDYGSPPY_PD") == true && model.YWDYGSPPY_PD != null)
              {
                  strUpdateSQL += ",YWDYGSPPY_PD='" + model.YWDYGSPPY_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDJGCZPYL") == true && model.YWDJGCZPYL != null)
              {
                  strUpdateSQL += ",YWDJGCZPYL='" + model.YWDJGCZPYL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDJGSPPYL") == true && model.YWDJGSPPYL != null)
              {
                  strUpdateSQL += ",YWDJGSPPYL='" + model.YWDJGSPPYL.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDJGDG") == true && model.YWDJGDG != null)
              {
                  strUpdateSQL += ",YWDJGDG='" + model.YWDJGDG.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDJGCZPY") == true && model.YWDJGCZPY != null)
              {
                  strUpdateSQL += ",YWDJGCZPY='" + model.YWDJGCZPY.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDJGCZPY_PD") == true && model.YWDJGCZPY_PD != null)
              {
                  strUpdateSQL += ",YWDJGCZPY_PD='" + model.YWDJGCZPY_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDJGSPPY") == true && model.YWDJGSPPY != null)
              {
                  strUpdateSQL += ",YWDJGSPPY='" + model.YWDJGSPPY.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDJGSPPY_PD") == true && model.YWDJGSPPY_PD != null)
              {
                  strUpdateSQL += ",YWDJGSPPY_PD='" + model.YWDJGSPPY_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDZ_PD") == true && model.YWDZ_PD != null)
              {
                  strUpdateSQL += ",YWDZ_PD='" + model.YWDZ_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("DGZGQ") == true && model.DGZGQ != null)
              {
                  strUpdateSQL += ",DGZGQ='" + model.DGZGQ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("DGZGQ_PD") == true && model.DGZGQ_PD != null)
              {
                  strUpdateSQL += ",DGZGQ_PD='" + model.DGZGQ_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("DGGQXZ") == true && model.DGGQXZ != null)
              {
                  strUpdateSQL += ",DGGQXZ='" + model.DGGQXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YGCZPYXZXX") == true && model.YGCZPYXZXX != null)
              {
                  strUpdateSQL += ",YGCZPYXZXX='" + model.YGCZPYXZXX.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YGCZPYXZSX") == true && model.YGCZPYXZSX != null)
              {
                  strUpdateSQL += ",YGCZPYXZSX='" + model.YGCZPYXZSX.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YGZDZPXZ") == true && model.YGZDZPXZ != null)
              {
                  strUpdateSQL += ",YGZDZPXZ='" + model.YGZDZPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YGZDYPXZ") == true && model.YGZDYPXZ != null)
              {
                  strUpdateSQL += ",YGZDYPXZ='" + model.YGZDYPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YGYDZPXZ") == true && model.YGYDZPXZ != null)
              {
                  strUpdateSQL += ",YGYDZPXZ='" + model.YGYDZPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YGYDYPXZ") == true && model.YGYDYPXZ != null)
              {
                  strUpdateSQL += ",YGYDYPXZ='" + model.YGYDYPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("JGCZPYXZXX") == true && model.JGCZPYXZXX != null)
              {
                  strUpdateSQL += ",JGCZPYXZXX='" + model.JGCZPYXZXX.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("JGCZPYXZSX") == true && model.JGCZPYXZSX != null)
              {
                  strUpdateSQL += ",JGCZPYXZSX='" + model.JGCZPYXZSX.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("JGZDZPXZ") == true && model.JGZDZPXZ != null)
              {
                  strUpdateSQL += ",JGZDZPXZ='" + model.JGZDZPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("JGZDYPXZ") == true && model.JGZDYPXZ != null)
              {
                  strUpdateSQL += ",JGZDYPXZ='" + model.JGZDYPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("JGYDZPXZ") == true && model.JGYDZPXZ != null)
              {
                  strUpdateSQL += ",JGYDZPXZ='" + model.JGYDZPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("JGYDYPXZ") == true && model.JGYDYPXZ != null)
              {
                  strUpdateSQL += ",JGYDYPXZ='" + model.JGYDYPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZGQXZ") == true && model.ZGQXZ != null)
              {
                  strUpdateSQL += ",ZGQXZ='" + model.ZGQXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("DGZ_PD") == true && model.DGZ_PD != null)
              {
                  strUpdateSQL += ",DGZ_PD='" + model.DGZ_PD.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("KSSJ") == true && model.KSSJ != null)
              {
                  strUpdateSQL += ",KSSJ='" + model.KSSJ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("JSSJ") == true && model.JSSJ != null)
              {
                  strUpdateSQL += ",JSSJ='" + model.JSSJ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("BIG1000JGCZPYXZXX") == true && model.BIG1000JGCZPYXZXX != null)
              {
                  strUpdateSQL += ",BIG1000JGCZPYXZXX='" + model.BIG1000JGCZPYXZXX.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("BIG1000JGCZPYXZSX") == true && model.BIG1000JGCZPYXZSX != null)
              {
                  strUpdateSQL += ",BIG1000JGCZPYXZSX='" + model.BIG1000JGCZPYXZSX.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDDGGQXZ") == true && model.ZWDDGGQXZ != null)
              {
                  strUpdateSQL += ",ZWDDGGQXZ='" + model.ZWDDGGQXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDYGCZPYXZSX") == true && model.ZWDYGCZPYXZSX != null)
              {
                  strUpdateSQL += ",ZWDYGCZPYXZSX='" + model.ZWDYGCZPYXZSX.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDYGCZPYXZXX") == true && model.ZWDYGCZPYXZXX != null)
              {
                  strUpdateSQL += ",ZWDYGCZPYXZXX='" + model.ZWDYGCZPYXZXX.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDJGCZPYXZSX") == true && model.ZWDJGCZPYXZSX != null)
              {
                  strUpdateSQL += ",ZWDJGCZPYXZSX='" + model.ZWDJGCZPYXZSX.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDJGCZPYXZXX") == true && model.ZWDJGCZPYXZXX != null)
              {
                  strUpdateSQL += ",ZWDJGCZPYXZXX='" + model.ZWDJGCZPYXZXX.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDYGZDYPXZ") == true && model.ZWDYGZDYPXZ != null)
              {
                  strUpdateSQL += ",ZWDYGZDYPXZ='" + model.ZWDYGZDYPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDYGZDZPXZ") == true && model.ZWDYGZDZPXZ != null)
              {
                  strUpdateSQL += ",ZWDYGZDZPXZ='" + model.ZWDYGZDZPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDYGYDYPXZ") == true && model.ZWDYGYDYPXZ != null)
              {
                  strUpdateSQL += ",ZWDYGYDYPXZ='" + model.ZWDYGYDYPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDYGYDZPXZ") == true && model.ZWDYGYDZPXZ != null)
              {
                  strUpdateSQL += ",ZWDYGYDZPXZ='" + model.ZWDYGYDZPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDJGZDYPXZ") == true && model.ZWDJGZDYPXZ != null)
              {
                  strUpdateSQL += ",ZWDJGZDYPXZ='" + model.ZWDJGZDYPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDJGZDZPXZ") == true && model.ZWDJGZDZPXZ != null)
              {
                  strUpdateSQL += ",ZWDJGZDZPXZ='" + model.ZWDJGZDZPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDJGYDYPXZ") == true && model.ZWDJGYDYPXZ != null)
              {
                  strUpdateSQL += ",ZWDJGYDYPXZ='" + model.ZWDJGYDYPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZWDJGYDZPXZ") == true && model.ZWDJGYDZPXZ != null)
              {
                  strUpdateSQL += ",ZWDJGYDZPXZ='" + model.ZWDJGYDZPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDDGGQXZ") == true && model.ZNDDGGQXZ != null)
              {
                  strUpdateSQL += ",ZNDDGGQXZ='" + model.ZNDDGGQXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDYGCZPYXZSX") == true && model.ZNDYGCZPYXZSX != null)
              {
                  strUpdateSQL += ",ZNDYGCZPYXZSX='" + model.ZNDYGCZPYXZSX.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDYGCZPYXZXX") == true && model.ZNDYGCZPYXZXX != null)
              {
                  strUpdateSQL += ",ZNDYGCZPYXZXX='" + model.ZNDYGCZPYXZXX.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDJGCZPYXZSX") == true && model.ZNDJGCZPYXZSX != null)
              {
                  strUpdateSQL += ",ZNDJGCZPYXZSX='" + model.ZNDJGCZPYXZSX.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDJGCZPYXZXX") == true && model.ZNDJGCZPYXZXX != null)
              {
                  strUpdateSQL += ",ZNDJGCZPYXZXX='" + model.ZNDJGCZPYXZXX.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDYGZDYPXZ") == true && model.ZNDYGZDYPXZ != null)
              {
                  strUpdateSQL += ",ZNDYGZDYPXZ='" + model.ZNDYGZDYPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDYGZDZPXZ") == true && model.ZNDYGZDZPXZ != null)
              {
                  strUpdateSQL += ",ZNDYGZDZPXZ='" + model.ZNDYGZDZPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDYGYDYPXZ") == true && model.ZNDYGYDYPXZ != null)
              {
                  strUpdateSQL += ",ZNDYGYDYPXZ='" + model.ZNDYGYDYPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDYGYDZPXZ") == true && model.ZNDYGYDZPXZ != null)
              {
                  strUpdateSQL += ",ZNDYGYDZPXZ='" + model.ZNDYGYDZPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDJGZDYPXZ") == true && model.ZNDJGZDYPXZ != null)
              {
                  strUpdateSQL += ",ZNDJGZDYPXZ='" + model.ZNDJGZDYPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDJGZDZPXZ") == true && model.ZNDJGZDZPXZ != null)
              {
                  strUpdateSQL += ",ZNDJGZDZPXZ='" + model.ZNDJGZDZPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDJGYDYPXZ") == true && model.ZNDJGYDYPXZ != null)
              {
                  strUpdateSQL += ",ZNDJGYDYPXZ='" + model.ZNDJGYDYPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("ZNDJGYDZPXZ") == true && model.ZNDJGYDZPXZ != null)
              {
                  strUpdateSQL += ",ZNDJGYDZPXZ='" + model.ZNDJGYDZPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDDGGQXZ") == true && model.YNDDGGQXZ != null)
              {
                  strUpdateSQL += ",YNDDGGQXZ='" + model.YNDDGGQXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDYGCZPYXZSX") == true && model.YNDYGCZPYXZSX != null)
              {
                  strUpdateSQL += ",YNDYGCZPYXZSX='" + model.YNDYGCZPYXZSX.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDYGCZPYXZXX") == true && model.YNDYGCZPYXZXX != null)
              {
                  strUpdateSQL += ",YNDYGCZPYXZXX='" + model.YNDYGCZPYXZXX.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDJGCZPYXZSX") == true && model.YNDJGCZPYXZSX != null)
              {
                  strUpdateSQL += ",YNDJGCZPYXZSX='" + model.YNDJGCZPYXZSX.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDJGCZPYXZXX") == true && model.YNDJGCZPYXZXX != null)
              {
                  strUpdateSQL += ",YNDJGCZPYXZXX='" + model.YNDJGCZPYXZXX.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDYGZDYPXZ") == true && model.YNDYGZDYPXZ != null)
              {
                  strUpdateSQL += ",YNDYGZDYPXZ='" + model.YNDYGZDYPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDYGZDZPXZ") == true && model.YNDYGZDZPXZ != null)
              {
                  strUpdateSQL += ",YNDYGZDZPXZ='" + model.YNDYGZDZPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDYGYDYPXZ") == true && model.YNDYGYDYPXZ != null)
              {
                  strUpdateSQL += ",YNDYGYDYPXZ='" + model.YNDYGYDYPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDYGYDZPXZ") == true && model.YNDYGYDZPXZ != null)
              {
                  strUpdateSQL += ",YNDYGYDZPXZ='" + model.YNDYGYDZPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDJGZDYPXZ") == true && model.YNDJGZDYPXZ != null)
              {
                  strUpdateSQL += ",YNDJGZDYPXZ='" + model.YNDJGZDYPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDJGZDZPXZ") == true && model.YNDJGZDZPXZ != null)
              {
                  strUpdateSQL += ",YNDJGZDZPXZ='" + model.YNDJGZDZPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDJGYDYPXZ") == true && model.YNDJGYDYPXZ != null)
              {
                  strUpdateSQL += ",YNDJGYDYPXZ='" + model.YNDJGYDYPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YNDJGYDZPXZ") == true && model.YNDJGYDZPXZ != null)
              {
                  strUpdateSQL += ",YNDJGYDZPXZ='" + model.YNDJGYDZPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDDGGQXZ") == true && model.YWDDGGQXZ != null)
              {
                  strUpdateSQL += ",YWDDGGQXZ='" + model.YWDDGGQXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDYGCZPYXZSX") == true && model.YWDYGCZPYXZSX != null)
              {
                  strUpdateSQL += ",YWDYGCZPYXZSX='" + model.YWDYGCZPYXZSX.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDYGCZPYXZXX") == true && model.YWDYGCZPYXZXX != null)
              {
                  strUpdateSQL += ",YWDYGCZPYXZXX='" + model.YWDYGCZPYXZXX.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDJGCZPYXZSX") == true && model.YWDJGCZPYXZSX != null)
              {
                  strUpdateSQL += ",YWDJGCZPYXZSX='" + model.YWDJGCZPYXZSX.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDJGCZPYXZXX") == true && model.YWDJGCZPYXZXX != null)
              {
                  strUpdateSQL += ",YWDJGCZPYXZXX='" + model.YWDJGCZPYXZXX.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDYGZDYPXZ") == true && model.YWDYGZDYPXZ != null)
              {
                  strUpdateSQL += ",YWDYGZDYPXZ='" + model.YWDYGZDYPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDYGZDZPXZ") == true && model.YWDYGZDZPXZ != null)
              {
                  strUpdateSQL += ",YWDYGZDZPXZ='" + model.YWDYGZDZPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDYGYDYPXZ") == true && model.YWDYGYDYPXZ != null)
              {
                  strUpdateSQL += ",YWDYGYDYPXZ='" + model.YWDYGYDYPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDYGYDZPXZ") == true && model.YWDYGYDZPXZ != null)
              {
                  strUpdateSQL += ",YWDYGYDZPXZ='" + model.YWDYGYDZPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDJGZDYPXZ") == true && model.YWDJGZDYPXZ != null)
              {
                  strUpdateSQL += ",YWDJGZDYPXZ='" + model.YWDJGZDYPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDJGZDZPXZ") == true && model.YWDJGZDZPXZ != null)
              {
                  strUpdateSQL += ",YWDJGZDZPXZ='" + model.YWDJGZDZPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDJGYDYPXZ") == true && model.YWDJGYDYPXZ != null)
              {
                  strUpdateSQL += ",YWDJGYDYPXZ='" + model.YWDJGYDYPXZ.ToString().Replace("'","''") + "'";
              }

              if(model.Changed("YWDJGYDZPXZ") == true && model.YWDJGYDZPXZ != null)
              {
                  strUpdateSQL += ",YWDJGYDZPXZ='" + model.YWDJGYDZPXZ.ToString().Replace("'","''") + "'";
              }

               string strSql = "";
               strSql += "update RESULT_LAMP set ";
               strSql += strUpdateSQL.Substring(1);
               strSql += " where ";
               strSql += " JCLSH='"+ strJCLSH +"'";

               return strSql;
          }

          /// <summary>
          /// 修改一条数据
          /// </summary>
          public bool Update(RESULT_LAMP model, string strJCLSH)
          {
              return DbHelper.ExecuteSql(UpdateSQL(model, strJCLSH));
          }

          /// <summary>
          /// 修改一个集合 SQL
          /// </summary>
           public string UpdateRangeSQL(RESULT_LAMP model, string p_strWhere)
          {
               string strUpdateSQL = "";

               if(model.Changed("ID") == true && model.ID != null)
               {
                  strUpdateSQL += ",ID=" + model.ID + "";
               }

               if(model.Changed("DGZWDJCCS") == true && model.DGZWDJCCS != null)
               {
                  strUpdateSQL += ",DGZWDJCCS='" + model.DGZWDJCCS.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("DGZNDJCCS") == true && model.DGZNDJCCS != null)
               {
                  strUpdateSQL += ",DGZNDJCCS='" + model.DGZNDJCCS.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("DGYNDJCCS") == true && model.DGYNDJCCS != null)
               {
                  strUpdateSQL += ",DGYNDJCCS='" + model.DGYNDJCCS.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("DGYWDJCCS") == true && model.DGYWDJCCS != null)
               {
                  strUpdateSQL += ",DGYWDJCCS='" + model.DGYWDJCCS.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("JCLSH") == true && model.JCLSH != null)
               {
                  strUpdateSQL += ",JCLSH='" + model.JCLSH.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZWDYGGQ") == true && model.ZWDYGGQ != null)
               {
                  strUpdateSQL += ",ZWDYGGQ='" + model.ZWDYGGQ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZWDYGGQ_PD") == true && model.ZWDYGGQ_PD != null)
               {
                  strUpdateSQL += ",ZWDYGGQ_PD='" + model.ZWDYGGQ_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZWDYGCZPYL") == true && model.ZWDYGCZPYL != null)
               {
                  strUpdateSQL += ",ZWDYGCZPYL='" + model.ZWDYGCZPYL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZWDYGSPPYL") == true && model.ZWDYGSPPYL != null)
               {
                  strUpdateSQL += ",ZWDYGSPPYL='" + model.ZWDYGSPPYL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZWDYGDG") == true && model.ZWDYGDG != null)
               {
                  strUpdateSQL += ",ZWDYGDG='" + model.ZWDYGDG.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZWDYGCZPY") == true && model.ZWDYGCZPY != null)
               {
                  strUpdateSQL += ",ZWDYGCZPY='" + model.ZWDYGCZPY.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZWDYGCZPY_PD") == true && model.ZWDYGCZPY_PD != null)
               {
                  strUpdateSQL += ",ZWDYGCZPY_PD='" + model.ZWDYGCZPY_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZWDYGSPPY") == true && model.ZWDYGSPPY != null)
               {
                  strUpdateSQL += ",ZWDYGSPPY='" + model.ZWDYGSPPY.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZWDYGSPPY_PD") == true && model.ZWDYGSPPY_PD != null)
               {
                  strUpdateSQL += ",ZWDYGSPPY_PD='" + model.ZWDYGSPPY_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZWDJGCZPYL") == true && model.ZWDJGCZPYL != null)
               {
                  strUpdateSQL += ",ZWDJGCZPYL='" + model.ZWDJGCZPYL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZWDJGSPPYL") == true && model.ZWDJGSPPYL != null)
               {
                  strUpdateSQL += ",ZWDJGSPPYL='" + model.ZWDJGSPPYL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZWDJGDG") == true && model.ZWDJGDG != null)
               {
                  strUpdateSQL += ",ZWDJGDG='" + model.ZWDJGDG.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZWDJGCZPY") == true && model.ZWDJGCZPY != null)
               {
                  strUpdateSQL += ",ZWDJGCZPY='" + model.ZWDJGCZPY.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZWDJGCZPY_PD") == true && model.ZWDJGCZPY_PD != null)
               {
                  strUpdateSQL += ",ZWDJGCZPY_PD='" + model.ZWDJGCZPY_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZWDJGSPPY") == true && model.ZWDJGSPPY != null)
               {
                  strUpdateSQL += ",ZWDJGSPPY='" + model.ZWDJGSPPY.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZWDJGSPPY_PD") == true && model.ZWDJGSPPY_PD != null)
               {
                  strUpdateSQL += ",ZWDJGSPPY_PD='" + model.ZWDJGSPPY_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZWDZ_PD") == true && model.ZWDZ_PD != null)
               {
                  strUpdateSQL += ",ZWDZ_PD='" + model.ZWDZ_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZNDYGGQ") == true && model.ZNDYGGQ != null)
               {
                  strUpdateSQL += ",ZNDYGGQ='" + model.ZNDYGGQ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZNDYGGQ_PD") == true && model.ZNDYGGQ_PD != null)
               {
                  strUpdateSQL += ",ZNDYGGQ_PD='" + model.ZNDYGGQ_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZNDYGCZPYL") == true && model.ZNDYGCZPYL != null)
               {
                  strUpdateSQL += ",ZNDYGCZPYL='" + model.ZNDYGCZPYL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZNDYGSPPYL") == true && model.ZNDYGSPPYL != null)
               {
                  strUpdateSQL += ",ZNDYGSPPYL='" + model.ZNDYGSPPYL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZNDYGDG") == true && model.ZNDYGDG != null)
               {
                  strUpdateSQL += ",ZNDYGDG='" + model.ZNDYGDG.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZNDYGCZPY") == true && model.ZNDYGCZPY != null)
               {
                  strUpdateSQL += ",ZNDYGCZPY='" + model.ZNDYGCZPY.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZNDYGCZPY_PD") == true && model.ZNDYGCZPY_PD != null)
               {
                  strUpdateSQL += ",ZNDYGCZPY_PD='" + model.ZNDYGCZPY_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZNDYGSPPY") == true && model.ZNDYGSPPY != null)
               {
                  strUpdateSQL += ",ZNDYGSPPY='" + model.ZNDYGSPPY.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZNDYGSPPY_PD") == true && model.ZNDYGSPPY_PD != null)
               {
                  strUpdateSQL += ",ZNDYGSPPY_PD='" + model.ZNDYGSPPY_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZNDJGCZPYL") == true && model.ZNDJGCZPYL != null)
               {
                  strUpdateSQL += ",ZNDJGCZPYL='" + model.ZNDJGCZPYL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZNDJGSPPYL") == true && model.ZNDJGSPPYL != null)
               {
                  strUpdateSQL += ",ZNDJGSPPYL='" + model.ZNDJGSPPYL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZNDJGDG") == true && model.ZNDJGDG != null)
               {
                  strUpdateSQL += ",ZNDJGDG='" + model.ZNDJGDG.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZNDJGCZPY") == true && model.ZNDJGCZPY != null)
               {
                  strUpdateSQL += ",ZNDJGCZPY='" + model.ZNDJGCZPY.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZNDJGCZPY_PD") == true && model.ZNDJGCZPY_PD != null)
               {
                  strUpdateSQL += ",ZNDJGCZPY_PD='" + model.ZNDJGCZPY_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZNDJGSPPY") == true && model.ZNDJGSPPY != null)
               {
                  strUpdateSQL += ",ZNDJGSPPY='" + model.ZNDJGSPPY.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZNDJGSPPY_PD") == true && model.ZNDJGSPPY_PD != null)
               {
                  strUpdateSQL += ",ZNDJGSPPY_PD='" + model.ZNDJGSPPY_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZNDZ_PD") == true && model.ZNDZ_PD != null)
               {
                  strUpdateSQL += ",ZNDZ_PD='" + model.ZNDZ_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YNDYGGQ") == true && model.YNDYGGQ != null)
               {
                  strUpdateSQL += ",YNDYGGQ='" + model.YNDYGGQ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YNDYGGQ_PD") == true && model.YNDYGGQ_PD != null)
               {
                  strUpdateSQL += ",YNDYGGQ_PD='" + model.YNDYGGQ_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YNDYGCZPYL") == true && model.YNDYGCZPYL != null)
               {
                  strUpdateSQL += ",YNDYGCZPYL='" + model.YNDYGCZPYL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YNDYGSPPYL") == true && model.YNDYGSPPYL != null)
               {
                  strUpdateSQL += ",YNDYGSPPYL='" + model.YNDYGSPPYL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YNDYGDG") == true && model.YNDYGDG != null)
               {
                  strUpdateSQL += ",YNDYGDG='" + model.YNDYGDG.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YNDYGCZPY") == true && model.YNDYGCZPY != null)
               {
                  strUpdateSQL += ",YNDYGCZPY='" + model.YNDYGCZPY.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YNDYGCZPY_PD") == true && model.YNDYGCZPY_PD != null)
               {
                  strUpdateSQL += ",YNDYGCZPY_PD='" + model.YNDYGCZPY_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YNDYGSPPY") == true && model.YNDYGSPPY != null)
               {
                  strUpdateSQL += ",YNDYGSPPY='" + model.YNDYGSPPY.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YNDYGSPPY_PD") == true && model.YNDYGSPPY_PD != null)
               {
                  strUpdateSQL += ",YNDYGSPPY_PD='" + model.YNDYGSPPY_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YNDJGCZPYL") == true && model.YNDJGCZPYL != null)
               {
                  strUpdateSQL += ",YNDJGCZPYL='" + model.YNDJGCZPYL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YNDJGSPPYL") == true && model.YNDJGSPPYL != null)
               {
                  strUpdateSQL += ",YNDJGSPPYL='" + model.YNDJGSPPYL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YNDJGDG") == true && model.YNDJGDG != null)
               {
                  strUpdateSQL += ",YNDJGDG='" + model.YNDJGDG.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YNDJGCZPY") == true && model.YNDJGCZPY != null)
               {
                  strUpdateSQL += ",YNDJGCZPY='" + model.YNDJGCZPY.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YNDJGCZPY_PD") == true && model.YNDJGCZPY_PD != null)
               {
                  strUpdateSQL += ",YNDJGCZPY_PD='" + model.YNDJGCZPY_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YNDJGSPPY") == true && model.YNDJGSPPY != null)
               {
                  strUpdateSQL += ",YNDJGSPPY='" + model.YNDJGSPPY.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YNDJGSPPY_PD") == true && model.YNDJGSPPY_PD != null)
               {
                  strUpdateSQL += ",YNDJGSPPY_PD='" + model.YNDJGSPPY_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YNDZ_PD") == true && model.YNDZ_PD != null)
               {
                  strUpdateSQL += ",YNDZ_PD='" + model.YNDZ_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YWDYGGQ") == true && model.YWDYGGQ != null)
               {
                  strUpdateSQL += ",YWDYGGQ='" + model.YWDYGGQ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YWDYGGQ_PD") == true && model.YWDYGGQ_PD != null)
               {
                  strUpdateSQL += ",YWDYGGQ_PD='" + model.YWDYGGQ_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YWDYGCZPYL") == true && model.YWDYGCZPYL != null)
               {
                  strUpdateSQL += ",YWDYGCZPYL='" + model.YWDYGCZPYL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YWDYGSPPYL") == true && model.YWDYGSPPYL != null)
               {
                  strUpdateSQL += ",YWDYGSPPYL='" + model.YWDYGSPPYL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YWDYGDG") == true && model.YWDYGDG != null)
               {
                  strUpdateSQL += ",YWDYGDG='" + model.YWDYGDG.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YWDYGCZPY") == true && model.YWDYGCZPY != null)
               {
                  strUpdateSQL += ",YWDYGCZPY='" + model.YWDYGCZPY.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YWDYGCZPY_PD") == true && model.YWDYGCZPY_PD != null)
               {
                  strUpdateSQL += ",YWDYGCZPY_PD='" + model.YWDYGCZPY_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YWDYGSPPY") == true && model.YWDYGSPPY != null)
               {
                  strUpdateSQL += ",YWDYGSPPY='" + model.YWDYGSPPY.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YWDYGSPPY_PD") == true && model.YWDYGSPPY_PD != null)
               {
                  strUpdateSQL += ",YWDYGSPPY_PD='" + model.YWDYGSPPY_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YWDJGCZPYL") == true && model.YWDJGCZPYL != null)
               {
                  strUpdateSQL += ",YWDJGCZPYL='" + model.YWDJGCZPYL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YWDJGSPPYL") == true && model.YWDJGSPPYL != null)
               {
                  strUpdateSQL += ",YWDJGSPPYL='" + model.YWDJGSPPYL.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YWDJGDG") == true && model.YWDJGDG != null)
               {
                  strUpdateSQL += ",YWDJGDG='" + model.YWDJGDG.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YWDJGCZPY") == true && model.YWDJGCZPY != null)
               {
                  strUpdateSQL += ",YWDJGCZPY='" + model.YWDJGCZPY.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YWDJGCZPY_PD") == true && model.YWDJGCZPY_PD != null)
               {
                  strUpdateSQL += ",YWDJGCZPY_PD='" + model.YWDJGCZPY_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YWDJGSPPY") == true && model.YWDJGSPPY != null)
               {
                  strUpdateSQL += ",YWDJGSPPY='" + model.YWDJGSPPY.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YWDJGSPPY_PD") == true && model.YWDJGSPPY_PD != null)
               {
                  strUpdateSQL += ",YWDJGSPPY_PD='" + model.YWDJGSPPY_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YWDZ_PD") == true && model.YWDZ_PD != null)
               {
                  strUpdateSQL += ",YWDZ_PD='" + model.YWDZ_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("DGZGQ") == true && model.DGZGQ != null)
               {
                  strUpdateSQL += ",DGZGQ='" + model.DGZGQ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("DGZGQ_PD") == true && model.DGZGQ_PD != null)
               {
                  strUpdateSQL += ",DGZGQ_PD='" + model.DGZGQ_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("DGGQXZ") == true && model.DGGQXZ != null)
               {
                  strUpdateSQL += ",DGGQXZ='" + model.DGGQXZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YGCZPYXZXX") == true && model.YGCZPYXZXX != null)
               {
                  strUpdateSQL += ",YGCZPYXZXX='" + model.YGCZPYXZXX.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YGCZPYXZSX") == true && model.YGCZPYXZSX != null)
               {
                  strUpdateSQL += ",YGCZPYXZSX='" + model.YGCZPYXZSX.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YGZDZPXZ") == true && model.YGZDZPXZ != null)
               {
                  strUpdateSQL += ",YGZDZPXZ='" + model.YGZDZPXZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YGZDYPXZ") == true && model.YGZDYPXZ != null)
               {
                  strUpdateSQL += ",YGZDYPXZ='" + model.YGZDYPXZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YGYDZPXZ") == true && model.YGYDZPXZ != null)
               {
                  strUpdateSQL += ",YGYDZPXZ='" + model.YGYDZPXZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YGYDYPXZ") == true && model.YGYDYPXZ != null)
               {
                  strUpdateSQL += ",YGYDYPXZ='" + model.YGYDYPXZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("JGCZPYXZXX") == true && model.JGCZPYXZXX != null)
               {
                  strUpdateSQL += ",JGCZPYXZXX='" + model.JGCZPYXZXX.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("JGCZPYXZSX") == true && model.JGCZPYXZSX != null)
               {
                  strUpdateSQL += ",JGCZPYXZSX='" + model.JGCZPYXZSX.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("JGZDZPXZ") == true && model.JGZDZPXZ != null)
               {
                  strUpdateSQL += ",JGZDZPXZ='" + model.JGZDZPXZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("JGZDYPXZ") == true && model.JGZDYPXZ != null)
               {
                  strUpdateSQL += ",JGZDYPXZ='" + model.JGZDYPXZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("JGYDZPXZ") == true && model.JGYDZPXZ != null)
               {
                  strUpdateSQL += ",JGYDZPXZ='" + model.JGYDZPXZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("JGYDYPXZ") == true && model.JGYDYPXZ != null)
               {
                  strUpdateSQL += ",JGYDYPXZ='" + model.JGYDYPXZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZGQXZ") == true && model.ZGQXZ != null)
               {
                  strUpdateSQL += ",ZGQXZ='" + model.ZGQXZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("DGZ_PD") == true && model.DGZ_PD != null)
               {
                  strUpdateSQL += ",DGZ_PD='" + model.DGZ_PD.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("KSSJ") == true && model.KSSJ != null)
               {
                  strUpdateSQL += ",KSSJ='" + model.KSSJ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("JSSJ") == true && model.JSSJ != null)
               {
                  strUpdateSQL += ",JSSJ='" + model.JSSJ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("BIG1000JGCZPYXZXX") == true && model.BIG1000JGCZPYXZXX != null)
               {
                  strUpdateSQL += ",BIG1000JGCZPYXZXX='" + model.BIG1000JGCZPYXZXX.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("BIG1000JGCZPYXZSX") == true && model.BIG1000JGCZPYXZSX != null)
               {
                  strUpdateSQL += ",BIG1000JGCZPYXZSX='" + model.BIG1000JGCZPYXZSX.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZWDDGGQXZ") == true && model.ZWDDGGQXZ != null)
               {
                  strUpdateSQL += ",ZWDDGGQXZ='" + model.ZWDDGGQXZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZWDYGCZPYXZSX") == true && model.ZWDYGCZPYXZSX != null)
               {
                  strUpdateSQL += ",ZWDYGCZPYXZSX='" + model.ZWDYGCZPYXZSX.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZWDYGCZPYXZXX") == true && model.ZWDYGCZPYXZXX != null)
               {
                  strUpdateSQL += ",ZWDYGCZPYXZXX='" + model.ZWDYGCZPYXZXX.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZWDJGCZPYXZSX") == true && model.ZWDJGCZPYXZSX != null)
               {
                  strUpdateSQL += ",ZWDJGCZPYXZSX='" + model.ZWDJGCZPYXZSX.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZWDJGCZPYXZXX") == true && model.ZWDJGCZPYXZXX != null)
               {
                  strUpdateSQL += ",ZWDJGCZPYXZXX='" + model.ZWDJGCZPYXZXX.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZWDYGZDYPXZ") == true && model.ZWDYGZDYPXZ != null)
               {
                  strUpdateSQL += ",ZWDYGZDYPXZ='" + model.ZWDYGZDYPXZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZWDYGZDZPXZ") == true && model.ZWDYGZDZPXZ != null)
               {
                  strUpdateSQL += ",ZWDYGZDZPXZ='" + model.ZWDYGZDZPXZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZWDYGYDYPXZ") == true && model.ZWDYGYDYPXZ != null)
               {
                  strUpdateSQL += ",ZWDYGYDYPXZ='" + model.ZWDYGYDYPXZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZWDYGYDZPXZ") == true && model.ZWDYGYDZPXZ != null)
               {
                  strUpdateSQL += ",ZWDYGYDZPXZ='" + model.ZWDYGYDZPXZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZWDJGZDYPXZ") == true && model.ZWDJGZDYPXZ != null)
               {
                  strUpdateSQL += ",ZWDJGZDYPXZ='" + model.ZWDJGZDYPXZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZWDJGZDZPXZ") == true && model.ZWDJGZDZPXZ != null)
               {
                  strUpdateSQL += ",ZWDJGZDZPXZ='" + model.ZWDJGZDZPXZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZWDJGYDYPXZ") == true && model.ZWDJGYDYPXZ != null)
               {
                  strUpdateSQL += ",ZWDJGYDYPXZ='" + model.ZWDJGYDYPXZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZWDJGYDZPXZ") == true && model.ZWDJGYDZPXZ != null)
               {
                  strUpdateSQL += ",ZWDJGYDZPXZ='" + model.ZWDJGYDZPXZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZNDDGGQXZ") == true && model.ZNDDGGQXZ != null)
               {
                  strUpdateSQL += ",ZNDDGGQXZ='" + model.ZNDDGGQXZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZNDYGCZPYXZSX") == true && model.ZNDYGCZPYXZSX != null)
               {
                  strUpdateSQL += ",ZNDYGCZPYXZSX='" + model.ZNDYGCZPYXZSX.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZNDYGCZPYXZXX") == true && model.ZNDYGCZPYXZXX != null)
               {
                  strUpdateSQL += ",ZNDYGCZPYXZXX='" + model.ZNDYGCZPYXZXX.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZNDJGCZPYXZSX") == true && model.ZNDJGCZPYXZSX != null)
               {
                  strUpdateSQL += ",ZNDJGCZPYXZSX='" + model.ZNDJGCZPYXZSX.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZNDJGCZPYXZXX") == true && model.ZNDJGCZPYXZXX != null)
               {
                  strUpdateSQL += ",ZNDJGCZPYXZXX='" + model.ZNDJGCZPYXZXX.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZNDYGZDYPXZ") == true && model.ZNDYGZDYPXZ != null)
               {
                  strUpdateSQL += ",ZNDYGZDYPXZ='" + model.ZNDYGZDYPXZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZNDYGZDZPXZ") == true && model.ZNDYGZDZPXZ != null)
               {
                  strUpdateSQL += ",ZNDYGZDZPXZ='" + model.ZNDYGZDZPXZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZNDYGYDYPXZ") == true && model.ZNDYGYDYPXZ != null)
               {
                  strUpdateSQL += ",ZNDYGYDYPXZ='" + model.ZNDYGYDYPXZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZNDYGYDZPXZ") == true && model.ZNDYGYDZPXZ != null)
               {
                  strUpdateSQL += ",ZNDYGYDZPXZ='" + model.ZNDYGYDZPXZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZNDJGZDYPXZ") == true && model.ZNDJGZDYPXZ != null)
               {
                  strUpdateSQL += ",ZNDJGZDYPXZ='" + model.ZNDJGZDYPXZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZNDJGZDZPXZ") == true && model.ZNDJGZDZPXZ != null)
               {
                  strUpdateSQL += ",ZNDJGZDZPXZ='" + model.ZNDJGZDZPXZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZNDJGYDYPXZ") == true && model.ZNDJGYDYPXZ != null)
               {
                  strUpdateSQL += ",ZNDJGYDYPXZ='" + model.ZNDJGYDYPXZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("ZNDJGYDZPXZ") == true && model.ZNDJGYDZPXZ != null)
               {
                  strUpdateSQL += ",ZNDJGYDZPXZ='" + model.ZNDJGYDZPXZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YNDDGGQXZ") == true && model.YNDDGGQXZ != null)
               {
                  strUpdateSQL += ",YNDDGGQXZ='" + model.YNDDGGQXZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YNDYGCZPYXZSX") == true && model.YNDYGCZPYXZSX != null)
               {
                  strUpdateSQL += ",YNDYGCZPYXZSX='" + model.YNDYGCZPYXZSX.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YNDYGCZPYXZXX") == true && model.YNDYGCZPYXZXX != null)
               {
                  strUpdateSQL += ",YNDYGCZPYXZXX='" + model.YNDYGCZPYXZXX.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YNDJGCZPYXZSX") == true && model.YNDJGCZPYXZSX != null)
               {
                  strUpdateSQL += ",YNDJGCZPYXZSX='" + model.YNDJGCZPYXZSX.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YNDJGCZPYXZXX") == true && model.YNDJGCZPYXZXX != null)
               {
                  strUpdateSQL += ",YNDJGCZPYXZXX='" + model.YNDJGCZPYXZXX.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YNDYGZDYPXZ") == true && model.YNDYGZDYPXZ != null)
               {
                  strUpdateSQL += ",YNDYGZDYPXZ='" + model.YNDYGZDYPXZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YNDYGZDZPXZ") == true && model.YNDYGZDZPXZ != null)
               {
                  strUpdateSQL += ",YNDYGZDZPXZ='" + model.YNDYGZDZPXZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YNDYGYDYPXZ") == true && model.YNDYGYDYPXZ != null)
               {
                  strUpdateSQL += ",YNDYGYDYPXZ='" + model.YNDYGYDYPXZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YNDYGYDZPXZ") == true && model.YNDYGYDZPXZ != null)
               {
                  strUpdateSQL += ",YNDYGYDZPXZ='" + model.YNDYGYDZPXZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YNDJGZDYPXZ") == true && model.YNDJGZDYPXZ != null)
               {
                  strUpdateSQL += ",YNDJGZDYPXZ='" + model.YNDJGZDYPXZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YNDJGZDZPXZ") == true && model.YNDJGZDZPXZ != null)
               {
                  strUpdateSQL += ",YNDJGZDZPXZ='" + model.YNDJGZDZPXZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YNDJGYDYPXZ") == true && model.YNDJGYDYPXZ != null)
               {
                  strUpdateSQL += ",YNDJGYDYPXZ='" + model.YNDJGYDYPXZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YNDJGYDZPXZ") == true && model.YNDJGYDZPXZ != null)
               {
                  strUpdateSQL += ",YNDJGYDZPXZ='" + model.YNDJGYDZPXZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YWDDGGQXZ") == true && model.YWDDGGQXZ != null)
               {
                  strUpdateSQL += ",YWDDGGQXZ='" + model.YWDDGGQXZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YWDYGCZPYXZSX") == true && model.YWDYGCZPYXZSX != null)
               {
                  strUpdateSQL += ",YWDYGCZPYXZSX='" + model.YWDYGCZPYXZSX.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YWDYGCZPYXZXX") == true && model.YWDYGCZPYXZXX != null)
               {
                  strUpdateSQL += ",YWDYGCZPYXZXX='" + model.YWDYGCZPYXZXX.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YWDJGCZPYXZSX") == true && model.YWDJGCZPYXZSX != null)
               {
                  strUpdateSQL += ",YWDJGCZPYXZSX='" + model.YWDJGCZPYXZSX.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YWDJGCZPYXZXX") == true && model.YWDJGCZPYXZXX != null)
               {
                  strUpdateSQL += ",YWDJGCZPYXZXX='" + model.YWDJGCZPYXZXX.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YWDYGZDYPXZ") == true && model.YWDYGZDYPXZ != null)
               {
                  strUpdateSQL += ",YWDYGZDYPXZ='" + model.YWDYGZDYPXZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YWDYGZDZPXZ") == true && model.YWDYGZDZPXZ != null)
               {
                  strUpdateSQL += ",YWDYGZDZPXZ='" + model.YWDYGZDZPXZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YWDYGYDYPXZ") == true && model.YWDYGYDYPXZ != null)
               {
                  strUpdateSQL += ",YWDYGYDYPXZ='" + model.YWDYGYDYPXZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YWDYGYDZPXZ") == true && model.YWDYGYDZPXZ != null)
               {
                  strUpdateSQL += ",YWDYGYDZPXZ='" + model.YWDYGYDZPXZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YWDJGZDYPXZ") == true && model.YWDJGZDYPXZ != null)
               {
                  strUpdateSQL += ",YWDJGZDYPXZ='" + model.YWDJGZDYPXZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YWDJGZDZPXZ") == true && model.YWDJGZDZPXZ != null)
               {
                  strUpdateSQL += ",YWDJGZDZPXZ='" + model.YWDJGZDZPXZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YWDJGYDYPXZ") == true && model.YWDJGYDYPXZ != null)
               {
                  strUpdateSQL += ",YWDJGYDYPXZ='" + model.YWDJGYDYPXZ.ToString().Replace("'","''") + "'";
               }

               if(model.Changed("YWDJGYDZPXZ") == true && model.YWDJGYDZPXZ != null)
               {
                  strUpdateSQL += ",YWDJGYDZPXZ='" + model.YWDJGYDZPXZ.ToString().Replace("'","''") + "'";
               }

              string strSql = "";
              strSql += "update RESULT_LAMP set ";
              strSql += strUpdateSQL.Substring(1);
              strSql += " where " + p_strWhere;

              return strSql;
          }

          /// <summary>
          /// 修改一个集合
          /// </summary>
          public bool UpdateRange(RESULT_LAMP model, string p_strWhere)
          {
              return DbHelper.ExecuteSql(UpdateRangeSQL(model, p_strWhere));
          }

          /// <summary>
          /// 修改全部数据 SQL
          /// </summary>
          public string UpdateAllSQL(RESULT_LAMP model)
          {
              string strUpdateSQL = "";

                  strUpdateSQL += ",ID=" + model.ID + "";
                  strUpdateSQL += ",DGZWDJCCS='" + model.DGZWDJCCS.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",DGZNDJCCS='" + model.DGZNDJCCS.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",DGYNDJCCS='" + model.DGYNDJCCS.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",DGYWDJCCS='" + model.DGYWDJCCS.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",JCLSH='" + model.JCLSH.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZWDYGGQ='" + model.ZWDYGGQ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZWDYGGQ_PD='" + model.ZWDYGGQ_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZWDYGCZPYL='" + model.ZWDYGCZPYL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZWDYGSPPYL='" + model.ZWDYGSPPYL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZWDYGDG='" + model.ZWDYGDG.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZWDYGCZPY='" + model.ZWDYGCZPY.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZWDYGCZPY_PD='" + model.ZWDYGCZPY_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZWDYGSPPY='" + model.ZWDYGSPPY.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZWDYGSPPY_PD='" + model.ZWDYGSPPY_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZWDJGCZPYL='" + model.ZWDJGCZPYL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZWDJGSPPYL='" + model.ZWDJGSPPYL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZWDJGDG='" + model.ZWDJGDG.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZWDJGCZPY='" + model.ZWDJGCZPY.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZWDJGCZPY_PD='" + model.ZWDJGCZPY_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZWDJGSPPY='" + model.ZWDJGSPPY.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZWDJGSPPY_PD='" + model.ZWDJGSPPY_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZWDZ_PD='" + model.ZWDZ_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZNDYGGQ='" + model.ZNDYGGQ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZNDYGGQ_PD='" + model.ZNDYGGQ_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZNDYGCZPYL='" + model.ZNDYGCZPYL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZNDYGSPPYL='" + model.ZNDYGSPPYL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZNDYGDG='" + model.ZNDYGDG.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZNDYGCZPY='" + model.ZNDYGCZPY.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZNDYGCZPY_PD='" + model.ZNDYGCZPY_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZNDYGSPPY='" + model.ZNDYGSPPY.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZNDYGSPPY_PD='" + model.ZNDYGSPPY_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZNDJGCZPYL='" + model.ZNDJGCZPYL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZNDJGSPPYL='" + model.ZNDJGSPPYL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZNDJGDG='" + model.ZNDJGDG.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZNDJGCZPY='" + model.ZNDJGCZPY.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZNDJGCZPY_PD='" + model.ZNDJGCZPY_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZNDJGSPPY='" + model.ZNDJGSPPY.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZNDJGSPPY_PD='" + model.ZNDJGSPPY_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZNDZ_PD='" + model.ZNDZ_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YNDYGGQ='" + model.YNDYGGQ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YNDYGGQ_PD='" + model.YNDYGGQ_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YNDYGCZPYL='" + model.YNDYGCZPYL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YNDYGSPPYL='" + model.YNDYGSPPYL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YNDYGDG='" + model.YNDYGDG.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YNDYGCZPY='" + model.YNDYGCZPY.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YNDYGCZPY_PD='" + model.YNDYGCZPY_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YNDYGSPPY='" + model.YNDYGSPPY.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YNDYGSPPY_PD='" + model.YNDYGSPPY_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YNDJGCZPYL='" + model.YNDJGCZPYL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YNDJGSPPYL='" + model.YNDJGSPPYL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YNDJGDG='" + model.YNDJGDG.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YNDJGCZPY='" + model.YNDJGCZPY.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YNDJGCZPY_PD='" + model.YNDJGCZPY_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YNDJGSPPY='" + model.YNDJGSPPY.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YNDJGSPPY_PD='" + model.YNDJGSPPY_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YNDZ_PD='" + model.YNDZ_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YWDYGGQ='" + model.YWDYGGQ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YWDYGGQ_PD='" + model.YWDYGGQ_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YWDYGCZPYL='" + model.YWDYGCZPYL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YWDYGSPPYL='" + model.YWDYGSPPYL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YWDYGDG='" + model.YWDYGDG.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YWDYGCZPY='" + model.YWDYGCZPY.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YWDYGCZPY_PD='" + model.YWDYGCZPY_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YWDYGSPPY='" + model.YWDYGSPPY.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YWDYGSPPY_PD='" + model.YWDYGSPPY_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YWDJGCZPYL='" + model.YWDJGCZPYL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YWDJGSPPYL='" + model.YWDJGSPPYL.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YWDJGDG='" + model.YWDJGDG.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YWDJGCZPY='" + model.YWDJGCZPY.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YWDJGCZPY_PD='" + model.YWDJGCZPY_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YWDJGSPPY='" + model.YWDJGSPPY.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YWDJGSPPY_PD='" + model.YWDJGSPPY_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YWDZ_PD='" + model.YWDZ_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",DGZGQ='" + model.DGZGQ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",DGZGQ_PD='" + model.DGZGQ_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",DGGQXZ='" + model.DGGQXZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YGCZPYXZXX='" + model.YGCZPYXZXX.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YGCZPYXZSX='" + model.YGCZPYXZSX.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YGZDZPXZ='" + model.YGZDZPXZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YGZDYPXZ='" + model.YGZDYPXZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YGYDZPXZ='" + model.YGYDZPXZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YGYDYPXZ='" + model.YGYDYPXZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",JGCZPYXZXX='" + model.JGCZPYXZXX.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",JGCZPYXZSX='" + model.JGCZPYXZSX.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",JGZDZPXZ='" + model.JGZDZPXZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",JGZDYPXZ='" + model.JGZDYPXZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",JGYDZPXZ='" + model.JGYDZPXZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",JGYDYPXZ='" + model.JGYDYPXZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZGQXZ='" + model.ZGQXZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",DGZ_PD='" + model.DGZ_PD.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",KSSJ='" + model.KSSJ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",JSSJ='" + model.JSSJ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",BIG1000JGCZPYXZXX='" + model.BIG1000JGCZPYXZXX.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",BIG1000JGCZPYXZSX='" + model.BIG1000JGCZPYXZSX.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZWDDGGQXZ='" + model.ZWDDGGQXZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZWDYGCZPYXZSX='" + model.ZWDYGCZPYXZSX.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZWDYGCZPYXZXX='" + model.ZWDYGCZPYXZXX.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZWDJGCZPYXZSX='" + model.ZWDJGCZPYXZSX.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZWDJGCZPYXZXX='" + model.ZWDJGCZPYXZXX.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZWDYGZDYPXZ='" + model.ZWDYGZDYPXZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZWDYGZDZPXZ='" + model.ZWDYGZDZPXZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZWDYGYDYPXZ='" + model.ZWDYGYDYPXZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZWDYGYDZPXZ='" + model.ZWDYGYDZPXZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZWDJGZDYPXZ='" + model.ZWDJGZDYPXZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZWDJGZDZPXZ='" + model.ZWDJGZDZPXZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZWDJGYDYPXZ='" + model.ZWDJGYDYPXZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZWDJGYDZPXZ='" + model.ZWDJGYDZPXZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZNDDGGQXZ='" + model.ZNDDGGQXZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZNDYGCZPYXZSX='" + model.ZNDYGCZPYXZSX.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZNDYGCZPYXZXX='" + model.ZNDYGCZPYXZXX.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZNDJGCZPYXZSX='" + model.ZNDJGCZPYXZSX.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZNDJGCZPYXZXX='" + model.ZNDJGCZPYXZXX.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZNDYGZDYPXZ='" + model.ZNDYGZDYPXZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZNDYGZDZPXZ='" + model.ZNDYGZDZPXZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZNDYGYDYPXZ='" + model.ZNDYGYDYPXZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZNDYGYDZPXZ='" + model.ZNDYGYDZPXZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZNDJGZDYPXZ='" + model.ZNDJGZDYPXZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZNDJGZDZPXZ='" + model.ZNDJGZDZPXZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZNDJGYDYPXZ='" + model.ZNDJGYDYPXZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",ZNDJGYDZPXZ='" + model.ZNDJGYDZPXZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YNDDGGQXZ='" + model.YNDDGGQXZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YNDYGCZPYXZSX='" + model.YNDYGCZPYXZSX.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YNDYGCZPYXZXX='" + model.YNDYGCZPYXZXX.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YNDJGCZPYXZSX='" + model.YNDJGCZPYXZSX.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YNDJGCZPYXZXX='" + model.YNDJGCZPYXZXX.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YNDYGZDYPXZ='" + model.YNDYGZDYPXZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YNDYGZDZPXZ='" + model.YNDYGZDZPXZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YNDYGYDYPXZ='" + model.YNDYGYDYPXZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YNDYGYDZPXZ='" + model.YNDYGYDZPXZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YNDJGZDYPXZ='" + model.YNDJGZDYPXZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YNDJGZDZPXZ='" + model.YNDJGZDZPXZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YNDJGYDYPXZ='" + model.YNDJGYDYPXZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YNDJGYDZPXZ='" + model.YNDJGYDZPXZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YWDDGGQXZ='" + model.YWDDGGQXZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YWDYGCZPYXZSX='" + model.YWDYGCZPYXZSX.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YWDYGCZPYXZXX='" + model.YWDYGCZPYXZXX.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YWDJGCZPYXZSX='" + model.YWDJGCZPYXZSX.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YWDJGCZPYXZXX='" + model.YWDJGCZPYXZXX.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YWDYGZDYPXZ='" + model.YWDYGZDYPXZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YWDYGZDZPXZ='" + model.YWDYGZDZPXZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YWDYGYDYPXZ='" + model.YWDYGYDYPXZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YWDYGYDZPXZ='" + model.YWDYGYDZPXZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YWDJGZDYPXZ='" + model.YWDJGZDYPXZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YWDJGZDZPXZ='" + model.YWDJGZDZPXZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YWDJGYDYPXZ='" + model.YWDJGYDYPXZ.ToString().Replace("'","''") + "'";
                  strUpdateSQL += ",YWDJGYDZPXZ='" + model.YWDJGYDZPXZ.ToString().Replace("'","''") + "'";


               string strSql = "";
               strSql += "update RESULT_LAMP set ";
               strSql += strUpdateSQL.Substring(1);

               return strSql;

          }

          /// <summary>
          /// 修改全部数据
          /// </summary>
          public bool UpdateAll(RESULT_LAMP model)
          {
              return DbHelper.ExecuteSql(UpdateAllSQL(model));
          }

          /// <summary>
          /// 删除一条数据 SQL
          /// </summary>
          public string DeleteSQL(string strJCLSH)
          {
              string strSql = "";
              strSql += "delete from RESULT_LAMP";
              strSql += " where ";
               strSql += " JCLSH='"+ strJCLSH +"'";

              return strSql;

          }

          /// <summary>
          /// 删除一条数据
          /// </summary>
          public bool Delete(string strJCLSH)
          {
              return DbHelper.ExecuteSql(DeleteSQL(strJCLSH));
          }

          /// <summary>
          /// 删除一个集合 SQL
          /// </summary>
          public string DeleteRangeSQL(string p_strWhere)
          {
              string strSql = "";
              strSql += "delete from RESULT_LAMP";
              strSql += " where " + p_strWhere;

              return strSql;
           }

          /// <summary>
          /// 删除一个集合
          /// </summary>
          public bool DeleteRange(string p_strWhere)
          {
              return DbHelper.ExecuteSql(DeleteRangeSQL(p_strWhere));
          }

          /// <summary>
          /// 删除全部 SQL
          /// </summary>
          public string DeleteAllSQL()
          {
              string strSql = "";
              strSql += "delete from RESULT_LAMP";

              return strSql;
           }

         /// <summary>
         /// 删除全部
         /// </summary>
         public bool DeleteAll()
         {
             return DbHelper.ExecuteSql(DeleteAllSQL());
         }

          /// <summary>
         /// 得到一个对象实体
         /// </summary>
         public RESULT_LAMP GetModel(string strJCLSH)
         {
             string strSql = "";
             strSql += "select * from RESULT_LAMP";
             strSql += " where ";
               strSql += " JCLSH='"+ strJCLSH +"'";

             DataTable dtTemp = new DataTable();
             DbHelper.GetTable(strSql, ref dtTemp);

             RESULT_LAMP model = new RESULT_LAMP();

             if(dtTemp.Rows.Count>0)
             {
                 model = new RESULT_LAMP();

                 model.ID = dtTemp.Rows[0]["ID"] == DBNull.Value ? 0 : Convert.ToInt32(dtTemp.Rows[0]["ID"]);
                 model.DGZWDJCCS = dtTemp.Rows[0]["DGZWDJCCS"] == DBNull.Value ? "" : dtTemp.Rows[0]["DGZWDJCCS"].ToString();
                 model.DGZNDJCCS = dtTemp.Rows[0]["DGZNDJCCS"] == DBNull.Value ? "" : dtTemp.Rows[0]["DGZNDJCCS"].ToString();
                 model.DGYNDJCCS = dtTemp.Rows[0]["DGYNDJCCS"] == DBNull.Value ? "" : dtTemp.Rows[0]["DGYNDJCCS"].ToString();
                 model.DGYWDJCCS = dtTemp.Rows[0]["DGYWDJCCS"] == DBNull.Value ? "" : dtTemp.Rows[0]["DGYWDJCCS"].ToString();
                 model.JCLSH = dtTemp.Rows[0]["JCLSH"] == DBNull.Value ? "" : dtTemp.Rows[0]["JCLSH"].ToString();
                 model.ZWDYGGQ = dtTemp.Rows[0]["ZWDYGGQ"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZWDYGGQ"].ToString();
                 model.ZWDYGGQ_PD = dtTemp.Rows[0]["ZWDYGGQ_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZWDYGGQ_PD"].ToString();
                 model.ZWDYGCZPYL = dtTemp.Rows[0]["ZWDYGCZPYL"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZWDYGCZPYL"].ToString();
                 model.ZWDYGSPPYL = dtTemp.Rows[0]["ZWDYGSPPYL"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZWDYGSPPYL"].ToString();
                 model.ZWDYGDG = dtTemp.Rows[0]["ZWDYGDG"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZWDYGDG"].ToString();
                 model.ZWDYGCZPY = dtTemp.Rows[0]["ZWDYGCZPY"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZWDYGCZPY"].ToString();
                 model.ZWDYGCZPY_PD = dtTemp.Rows[0]["ZWDYGCZPY_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZWDYGCZPY_PD"].ToString();
                 model.ZWDYGSPPY = dtTemp.Rows[0]["ZWDYGSPPY"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZWDYGSPPY"].ToString();
                 model.ZWDYGSPPY_PD = dtTemp.Rows[0]["ZWDYGSPPY_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZWDYGSPPY_PD"].ToString();
                 model.ZWDJGCZPYL = dtTemp.Rows[0]["ZWDJGCZPYL"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZWDJGCZPYL"].ToString();
                 model.ZWDJGSPPYL = dtTemp.Rows[0]["ZWDJGSPPYL"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZWDJGSPPYL"].ToString();
                 model.ZWDJGDG = dtTemp.Rows[0]["ZWDJGDG"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZWDJGDG"].ToString();
                 model.ZWDJGCZPY = dtTemp.Rows[0]["ZWDJGCZPY"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZWDJGCZPY"].ToString();
                 model.ZWDJGCZPY_PD = dtTemp.Rows[0]["ZWDJGCZPY_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZWDJGCZPY_PD"].ToString();
                 model.ZWDJGSPPY = dtTemp.Rows[0]["ZWDJGSPPY"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZWDJGSPPY"].ToString();
                 model.ZWDJGSPPY_PD = dtTemp.Rows[0]["ZWDJGSPPY_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZWDJGSPPY_PD"].ToString();
                 model.ZWDZ_PD = dtTemp.Rows[0]["ZWDZ_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZWDZ_PD"].ToString();
                 model.ZNDYGGQ = dtTemp.Rows[0]["ZNDYGGQ"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZNDYGGQ"].ToString();
                 model.ZNDYGGQ_PD = dtTemp.Rows[0]["ZNDYGGQ_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZNDYGGQ_PD"].ToString();
                 model.ZNDYGCZPYL = dtTemp.Rows[0]["ZNDYGCZPYL"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZNDYGCZPYL"].ToString();
                 model.ZNDYGSPPYL = dtTemp.Rows[0]["ZNDYGSPPYL"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZNDYGSPPYL"].ToString();
                 model.ZNDYGDG = dtTemp.Rows[0]["ZNDYGDG"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZNDYGDG"].ToString();
                 model.ZNDYGCZPY = dtTemp.Rows[0]["ZNDYGCZPY"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZNDYGCZPY"].ToString();
                 model.ZNDYGCZPY_PD = dtTemp.Rows[0]["ZNDYGCZPY_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZNDYGCZPY_PD"].ToString();
                 model.ZNDYGSPPY = dtTemp.Rows[0]["ZNDYGSPPY"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZNDYGSPPY"].ToString();
                 model.ZNDYGSPPY_PD = dtTemp.Rows[0]["ZNDYGSPPY_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZNDYGSPPY_PD"].ToString();
                 model.ZNDJGCZPYL = dtTemp.Rows[0]["ZNDJGCZPYL"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZNDJGCZPYL"].ToString();
                 model.ZNDJGSPPYL = dtTemp.Rows[0]["ZNDJGSPPYL"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZNDJGSPPYL"].ToString();
                 model.ZNDJGDG = dtTemp.Rows[0]["ZNDJGDG"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZNDJGDG"].ToString();
                 model.ZNDJGCZPY = dtTemp.Rows[0]["ZNDJGCZPY"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZNDJGCZPY"].ToString();
                 model.ZNDJGCZPY_PD = dtTemp.Rows[0]["ZNDJGCZPY_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZNDJGCZPY_PD"].ToString();
                 model.ZNDJGSPPY = dtTemp.Rows[0]["ZNDJGSPPY"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZNDJGSPPY"].ToString();
                 model.ZNDJGSPPY_PD = dtTemp.Rows[0]["ZNDJGSPPY_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZNDJGSPPY_PD"].ToString();
                 model.ZNDZ_PD = dtTemp.Rows[0]["ZNDZ_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZNDZ_PD"].ToString();
                 model.YNDYGGQ = dtTemp.Rows[0]["YNDYGGQ"] == DBNull.Value ? "" : dtTemp.Rows[0]["YNDYGGQ"].ToString();
                 model.YNDYGGQ_PD = dtTemp.Rows[0]["YNDYGGQ_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["YNDYGGQ_PD"].ToString();
                 model.YNDYGCZPYL = dtTemp.Rows[0]["YNDYGCZPYL"] == DBNull.Value ? "" : dtTemp.Rows[0]["YNDYGCZPYL"].ToString();
                 model.YNDYGSPPYL = dtTemp.Rows[0]["YNDYGSPPYL"] == DBNull.Value ? "" : dtTemp.Rows[0]["YNDYGSPPYL"].ToString();
                 model.YNDYGDG = dtTemp.Rows[0]["YNDYGDG"] == DBNull.Value ? "" : dtTemp.Rows[0]["YNDYGDG"].ToString();
                 model.YNDYGCZPY = dtTemp.Rows[0]["YNDYGCZPY"] == DBNull.Value ? "" : dtTemp.Rows[0]["YNDYGCZPY"].ToString();
                 model.YNDYGCZPY_PD = dtTemp.Rows[0]["YNDYGCZPY_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["YNDYGCZPY_PD"].ToString();
                 model.YNDYGSPPY = dtTemp.Rows[0]["YNDYGSPPY"] == DBNull.Value ? "" : dtTemp.Rows[0]["YNDYGSPPY"].ToString();
                 model.YNDYGSPPY_PD = dtTemp.Rows[0]["YNDYGSPPY_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["YNDYGSPPY_PD"].ToString();
                 model.YNDJGCZPYL = dtTemp.Rows[0]["YNDJGCZPYL"] == DBNull.Value ? "" : dtTemp.Rows[0]["YNDJGCZPYL"].ToString();
                 model.YNDJGSPPYL = dtTemp.Rows[0]["YNDJGSPPYL"] == DBNull.Value ? "" : dtTemp.Rows[0]["YNDJGSPPYL"].ToString();
                 model.YNDJGDG = dtTemp.Rows[0]["YNDJGDG"] == DBNull.Value ? "" : dtTemp.Rows[0]["YNDJGDG"].ToString();
                 model.YNDJGCZPY = dtTemp.Rows[0]["YNDJGCZPY"] == DBNull.Value ? "" : dtTemp.Rows[0]["YNDJGCZPY"].ToString();
                 model.YNDJGCZPY_PD = dtTemp.Rows[0]["YNDJGCZPY_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["YNDJGCZPY_PD"].ToString();
                 model.YNDJGSPPY = dtTemp.Rows[0]["YNDJGSPPY"] == DBNull.Value ? "" : dtTemp.Rows[0]["YNDJGSPPY"].ToString();
                 model.YNDJGSPPY_PD = dtTemp.Rows[0]["YNDJGSPPY_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["YNDJGSPPY_PD"].ToString();
                 model.YNDZ_PD = dtTemp.Rows[0]["YNDZ_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["YNDZ_PD"].ToString();
                 model.YWDYGGQ = dtTemp.Rows[0]["YWDYGGQ"] == DBNull.Value ? "" : dtTemp.Rows[0]["YWDYGGQ"].ToString();
                 model.YWDYGGQ_PD = dtTemp.Rows[0]["YWDYGGQ_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["YWDYGGQ_PD"].ToString();
                 model.YWDYGCZPYL = dtTemp.Rows[0]["YWDYGCZPYL"] == DBNull.Value ? "" : dtTemp.Rows[0]["YWDYGCZPYL"].ToString();
                 model.YWDYGSPPYL = dtTemp.Rows[0]["YWDYGSPPYL"] == DBNull.Value ? "" : dtTemp.Rows[0]["YWDYGSPPYL"].ToString();
                 model.YWDYGDG = dtTemp.Rows[0]["YWDYGDG"] == DBNull.Value ? "" : dtTemp.Rows[0]["YWDYGDG"].ToString();
                 model.YWDYGCZPY = dtTemp.Rows[0]["YWDYGCZPY"] == DBNull.Value ? "" : dtTemp.Rows[0]["YWDYGCZPY"].ToString();
                 model.YWDYGCZPY_PD = dtTemp.Rows[0]["YWDYGCZPY_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["YWDYGCZPY_PD"].ToString();
                 model.YWDYGSPPY = dtTemp.Rows[0]["YWDYGSPPY"] == DBNull.Value ? "" : dtTemp.Rows[0]["YWDYGSPPY"].ToString();
                 model.YWDYGSPPY_PD = dtTemp.Rows[0]["YWDYGSPPY_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["YWDYGSPPY_PD"].ToString();
                 model.YWDJGCZPYL = dtTemp.Rows[0]["YWDJGCZPYL"] == DBNull.Value ? "" : dtTemp.Rows[0]["YWDJGCZPYL"].ToString();
                 model.YWDJGSPPYL = dtTemp.Rows[0]["YWDJGSPPYL"] == DBNull.Value ? "" : dtTemp.Rows[0]["YWDJGSPPYL"].ToString();
                 model.YWDJGDG = dtTemp.Rows[0]["YWDJGDG"] == DBNull.Value ? "" : dtTemp.Rows[0]["YWDJGDG"].ToString();
                 model.YWDJGCZPY = dtTemp.Rows[0]["YWDJGCZPY"] == DBNull.Value ? "" : dtTemp.Rows[0]["YWDJGCZPY"].ToString();
                 model.YWDJGCZPY_PD = dtTemp.Rows[0]["YWDJGCZPY_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["YWDJGCZPY_PD"].ToString();
                 model.YWDJGSPPY = dtTemp.Rows[0]["YWDJGSPPY"] == DBNull.Value ? "" : dtTemp.Rows[0]["YWDJGSPPY"].ToString();
                 model.YWDJGSPPY_PD = dtTemp.Rows[0]["YWDJGSPPY_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["YWDJGSPPY_PD"].ToString();
                 model.YWDZ_PD = dtTemp.Rows[0]["YWDZ_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["YWDZ_PD"].ToString();
                 model.DGZGQ = dtTemp.Rows[0]["DGZGQ"] == DBNull.Value ? "" : dtTemp.Rows[0]["DGZGQ"].ToString();
                 model.DGZGQ_PD = dtTemp.Rows[0]["DGZGQ_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["DGZGQ_PD"].ToString();
                 model.DGGQXZ = dtTemp.Rows[0]["DGGQXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["DGGQXZ"].ToString();
                 model.YGCZPYXZXX = dtTemp.Rows[0]["YGCZPYXZXX"] == DBNull.Value ? "" : dtTemp.Rows[0]["YGCZPYXZXX"].ToString();
                 model.YGCZPYXZSX = dtTemp.Rows[0]["YGCZPYXZSX"] == DBNull.Value ? "" : dtTemp.Rows[0]["YGCZPYXZSX"].ToString();
                 model.YGZDZPXZ = dtTemp.Rows[0]["YGZDZPXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["YGZDZPXZ"].ToString();
                 model.YGZDYPXZ = dtTemp.Rows[0]["YGZDYPXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["YGZDYPXZ"].ToString();
                 model.YGYDZPXZ = dtTemp.Rows[0]["YGYDZPXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["YGYDZPXZ"].ToString();
                 model.YGYDYPXZ = dtTemp.Rows[0]["YGYDYPXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["YGYDYPXZ"].ToString();
                 model.JGCZPYXZXX = dtTemp.Rows[0]["JGCZPYXZXX"] == DBNull.Value ? "" : dtTemp.Rows[0]["JGCZPYXZXX"].ToString();
                 model.JGCZPYXZSX = dtTemp.Rows[0]["JGCZPYXZSX"] == DBNull.Value ? "" : dtTemp.Rows[0]["JGCZPYXZSX"].ToString();
                 model.JGZDZPXZ = dtTemp.Rows[0]["JGZDZPXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["JGZDZPXZ"].ToString();
                 model.JGZDYPXZ = dtTemp.Rows[0]["JGZDYPXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["JGZDYPXZ"].ToString();
                 model.JGYDZPXZ = dtTemp.Rows[0]["JGYDZPXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["JGYDZPXZ"].ToString();
                 model.JGYDYPXZ = dtTemp.Rows[0]["JGYDYPXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["JGYDYPXZ"].ToString();
                 model.ZGQXZ = dtTemp.Rows[0]["ZGQXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZGQXZ"].ToString();
                 model.DGZ_PD = dtTemp.Rows[0]["DGZ_PD"] == DBNull.Value ? "" : dtTemp.Rows[0]["DGZ_PD"].ToString();
                 model.KSSJ = dtTemp.Rows[0]["KSSJ"] == DBNull.Value ? "" : dtTemp.Rows[0]["KSSJ"].ToString();
                 model.JSSJ = dtTemp.Rows[0]["JSSJ"] == DBNull.Value ? "" : dtTemp.Rows[0]["JSSJ"].ToString();
                 model.BIG1000JGCZPYXZXX = dtTemp.Rows[0]["BIG1000JGCZPYXZXX"] == DBNull.Value ? "" : dtTemp.Rows[0]["BIG1000JGCZPYXZXX"].ToString();
                 model.BIG1000JGCZPYXZSX = dtTemp.Rows[0]["BIG1000JGCZPYXZSX"] == DBNull.Value ? "" : dtTemp.Rows[0]["BIG1000JGCZPYXZSX"].ToString();
                 model.ZWDDGGQXZ = dtTemp.Rows[0]["ZWDDGGQXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZWDDGGQXZ"].ToString();
                 model.ZWDYGCZPYXZSX = dtTemp.Rows[0]["ZWDYGCZPYXZSX"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZWDYGCZPYXZSX"].ToString();
                 model.ZWDYGCZPYXZXX = dtTemp.Rows[0]["ZWDYGCZPYXZXX"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZWDYGCZPYXZXX"].ToString();
                 model.ZWDJGCZPYXZSX = dtTemp.Rows[0]["ZWDJGCZPYXZSX"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZWDJGCZPYXZSX"].ToString();
                 model.ZWDJGCZPYXZXX = dtTemp.Rows[0]["ZWDJGCZPYXZXX"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZWDJGCZPYXZXX"].ToString();
                 model.ZWDYGZDYPXZ = dtTemp.Rows[0]["ZWDYGZDYPXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZWDYGZDYPXZ"].ToString();
                 model.ZWDYGZDZPXZ = dtTemp.Rows[0]["ZWDYGZDZPXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZWDYGZDZPXZ"].ToString();
                 model.ZWDYGYDYPXZ = dtTemp.Rows[0]["ZWDYGYDYPXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZWDYGYDYPXZ"].ToString();
                 model.ZWDYGYDZPXZ = dtTemp.Rows[0]["ZWDYGYDZPXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZWDYGYDZPXZ"].ToString();
                 model.ZWDJGZDYPXZ = dtTemp.Rows[0]["ZWDJGZDYPXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZWDJGZDYPXZ"].ToString();
                 model.ZWDJGZDZPXZ = dtTemp.Rows[0]["ZWDJGZDZPXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZWDJGZDZPXZ"].ToString();
                 model.ZWDJGYDYPXZ = dtTemp.Rows[0]["ZWDJGYDYPXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZWDJGYDYPXZ"].ToString();
                 model.ZWDJGYDZPXZ = dtTemp.Rows[0]["ZWDJGYDZPXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZWDJGYDZPXZ"].ToString();
                 model.ZNDDGGQXZ = dtTemp.Rows[0]["ZNDDGGQXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZNDDGGQXZ"].ToString();
                 model.ZNDYGCZPYXZSX = dtTemp.Rows[0]["ZNDYGCZPYXZSX"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZNDYGCZPYXZSX"].ToString();
                 model.ZNDYGCZPYXZXX = dtTemp.Rows[0]["ZNDYGCZPYXZXX"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZNDYGCZPYXZXX"].ToString();
                 model.ZNDJGCZPYXZSX = dtTemp.Rows[0]["ZNDJGCZPYXZSX"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZNDJGCZPYXZSX"].ToString();
                 model.ZNDJGCZPYXZXX = dtTemp.Rows[0]["ZNDJGCZPYXZXX"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZNDJGCZPYXZXX"].ToString();
                 model.ZNDYGZDYPXZ = dtTemp.Rows[0]["ZNDYGZDYPXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZNDYGZDYPXZ"].ToString();
                 model.ZNDYGZDZPXZ = dtTemp.Rows[0]["ZNDYGZDZPXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZNDYGZDZPXZ"].ToString();
                 model.ZNDYGYDYPXZ = dtTemp.Rows[0]["ZNDYGYDYPXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZNDYGYDYPXZ"].ToString();
                 model.ZNDYGYDZPXZ = dtTemp.Rows[0]["ZNDYGYDZPXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZNDYGYDZPXZ"].ToString();
                 model.ZNDJGZDYPXZ = dtTemp.Rows[0]["ZNDJGZDYPXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZNDJGZDYPXZ"].ToString();
                 model.ZNDJGZDZPXZ = dtTemp.Rows[0]["ZNDJGZDZPXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZNDJGZDZPXZ"].ToString();
                 model.ZNDJGYDYPXZ = dtTemp.Rows[0]["ZNDJGYDYPXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZNDJGYDYPXZ"].ToString();
                 model.ZNDJGYDZPXZ = dtTemp.Rows[0]["ZNDJGYDZPXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["ZNDJGYDZPXZ"].ToString();
                 model.YNDDGGQXZ = dtTemp.Rows[0]["YNDDGGQXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["YNDDGGQXZ"].ToString();
                 model.YNDYGCZPYXZSX = dtTemp.Rows[0]["YNDYGCZPYXZSX"] == DBNull.Value ? "" : dtTemp.Rows[0]["YNDYGCZPYXZSX"].ToString();
                 model.YNDYGCZPYXZXX = dtTemp.Rows[0]["YNDYGCZPYXZXX"] == DBNull.Value ? "" : dtTemp.Rows[0]["YNDYGCZPYXZXX"].ToString();
                 model.YNDJGCZPYXZSX = dtTemp.Rows[0]["YNDJGCZPYXZSX"] == DBNull.Value ? "" : dtTemp.Rows[0]["YNDJGCZPYXZSX"].ToString();
                 model.YNDJGCZPYXZXX = dtTemp.Rows[0]["YNDJGCZPYXZXX"] == DBNull.Value ? "" : dtTemp.Rows[0]["YNDJGCZPYXZXX"].ToString();
                 model.YNDYGZDYPXZ = dtTemp.Rows[0]["YNDYGZDYPXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["YNDYGZDYPXZ"].ToString();
                 model.YNDYGZDZPXZ = dtTemp.Rows[0]["YNDYGZDZPXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["YNDYGZDZPXZ"].ToString();
                 model.YNDYGYDYPXZ = dtTemp.Rows[0]["YNDYGYDYPXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["YNDYGYDYPXZ"].ToString();
                 model.YNDYGYDZPXZ = dtTemp.Rows[0]["YNDYGYDZPXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["YNDYGYDZPXZ"].ToString();
                 model.YNDJGZDYPXZ = dtTemp.Rows[0]["YNDJGZDYPXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["YNDJGZDYPXZ"].ToString();
                 model.YNDJGZDZPXZ = dtTemp.Rows[0]["YNDJGZDZPXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["YNDJGZDZPXZ"].ToString();
                 model.YNDJGYDYPXZ = dtTemp.Rows[0]["YNDJGYDYPXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["YNDJGYDYPXZ"].ToString();
                 model.YNDJGYDZPXZ = dtTemp.Rows[0]["YNDJGYDZPXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["YNDJGYDZPXZ"].ToString();
                 model.YWDDGGQXZ = dtTemp.Rows[0]["YWDDGGQXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["YWDDGGQXZ"].ToString();
                 model.YWDYGCZPYXZSX = dtTemp.Rows[0]["YWDYGCZPYXZSX"] == DBNull.Value ? "" : dtTemp.Rows[0]["YWDYGCZPYXZSX"].ToString();
                 model.YWDYGCZPYXZXX = dtTemp.Rows[0]["YWDYGCZPYXZXX"] == DBNull.Value ? "" : dtTemp.Rows[0]["YWDYGCZPYXZXX"].ToString();
                 model.YWDJGCZPYXZSX = dtTemp.Rows[0]["YWDJGCZPYXZSX"] == DBNull.Value ? "" : dtTemp.Rows[0]["YWDJGCZPYXZSX"].ToString();
                 model.YWDJGCZPYXZXX = dtTemp.Rows[0]["YWDJGCZPYXZXX"] == DBNull.Value ? "" : dtTemp.Rows[0]["YWDJGCZPYXZXX"].ToString();
                 model.YWDYGZDYPXZ = dtTemp.Rows[0]["YWDYGZDYPXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["YWDYGZDYPXZ"].ToString();
                 model.YWDYGZDZPXZ = dtTemp.Rows[0]["YWDYGZDZPXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["YWDYGZDZPXZ"].ToString();
                 model.YWDYGYDYPXZ = dtTemp.Rows[0]["YWDYGYDYPXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["YWDYGYDYPXZ"].ToString();
                 model.YWDYGYDZPXZ = dtTemp.Rows[0]["YWDYGYDZPXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["YWDYGYDZPXZ"].ToString();
                 model.YWDJGZDYPXZ = dtTemp.Rows[0]["YWDJGZDYPXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["YWDJGZDYPXZ"].ToString();
                 model.YWDJGZDZPXZ = dtTemp.Rows[0]["YWDJGZDZPXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["YWDJGZDZPXZ"].ToString();
                 model.YWDJGYDYPXZ = dtTemp.Rows[0]["YWDJGYDYPXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["YWDJGYDYPXZ"].ToString();
                 model.YWDJGYDZPXZ = dtTemp.Rows[0]["YWDJGYDZPXZ"] == DBNull.Value ? "" : dtTemp.Rows[0]["YWDJGYDZPXZ"].ToString();
             }

             dtTemp.Dispose();

             return model;
         }

         /// <summary>
         /// 得到一个对象实体
         /// </summary>
         public void GetModel(ref DataTable p_dtData, string strJCLSH)
         {
             p_dtData.Clear();

             string strSql = "";
             strSql += "select * from RESULT_LAMP";
             strSql += " where ";
               strSql += " JCLSH='"+ strJCLSH +"'";

              DbHelper.GetTable(strSql, ref p_dtData);
         }

      /// <summary>
      /// 得到对象集合
      /// </summary>
      public RESULT_LAMP[] GetModelList(string p_strWhere, string p_strOrder, int p_intPageNumber, int p_intPageSize)
      {
          int m_intPageNumber = p_intPageNumber;
          int m_intPageCount = GetPageCount(p_strWhere, p_intPageSize);

          if((m_intPageNumber < 1) || (m_intPageNumber == 0))
          {
               m_intPageNumber = 1;
          }

          if(m_intPageNumber == -1)
          {
               m_intPageNumber = m_intPageCount;
          }

          if(m_intPageNumber > m_intPageCount)
          {
               m_intPageNumber = m_intPageCount;
          }

          string strSql = "";
          strSql += "select * from RESULT_LAMP";
          if(p_strWhere.Trim().Length > 0)
          {
               strSql += " where " + p_strWhere;
          }
          if(p_strOrder.Trim().Length > 0)
          {
               strSql += " order by " + p_strOrder;
          }

          DataTable dtTemp = new DataTable();

          if(p_intPageSize > 0)
          {
               DbHelper.GetTable(strSql, ref dtTemp, (m_intPageNumber-1)*p_intPageSize, p_intPageSize);
          }
          else
          {
               DbHelper.GetTable(strSql, ref dtTemp);
          }

          RESULT_LAMP[] arrModel=new RESULT_LAMP[dtTemp.Rows.Count];

          for(int N=0;N<dtTemp.Rows.Count;N++)
          {
               arrModel[N] = new RESULT_LAMP();

                 arrModel[N].ID = dtTemp.Rows[N]["ID"] == DBNull.Value ? 0 : Convert.ToInt32(dtTemp.Rows[N]["ID"]);
                 arrModel[N].DGZWDJCCS = dtTemp.Rows[N]["DGZWDJCCS"] == DBNull.Value ? "" : dtTemp.Rows[N]["DGZWDJCCS"].ToString();
                 arrModel[N].DGZNDJCCS = dtTemp.Rows[N]["DGZNDJCCS"] == DBNull.Value ? "" : dtTemp.Rows[N]["DGZNDJCCS"].ToString();
                 arrModel[N].DGYNDJCCS = dtTemp.Rows[N]["DGYNDJCCS"] == DBNull.Value ? "" : dtTemp.Rows[N]["DGYNDJCCS"].ToString();
                 arrModel[N].DGYWDJCCS = dtTemp.Rows[N]["DGYWDJCCS"] == DBNull.Value ? "" : dtTemp.Rows[N]["DGYWDJCCS"].ToString();
                 arrModel[N].JCLSH = dtTemp.Rows[N]["JCLSH"] == DBNull.Value ? "" : dtTemp.Rows[N]["JCLSH"].ToString();
                 arrModel[N].ZWDYGGQ = dtTemp.Rows[N]["ZWDYGGQ"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZWDYGGQ"].ToString();
                 arrModel[N].ZWDYGGQ_PD = dtTemp.Rows[N]["ZWDYGGQ_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZWDYGGQ_PD"].ToString();
                 arrModel[N].ZWDYGCZPYL = dtTemp.Rows[N]["ZWDYGCZPYL"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZWDYGCZPYL"].ToString();
                 arrModel[N].ZWDYGSPPYL = dtTemp.Rows[N]["ZWDYGSPPYL"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZWDYGSPPYL"].ToString();
                 arrModel[N].ZWDYGDG = dtTemp.Rows[N]["ZWDYGDG"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZWDYGDG"].ToString();
                 arrModel[N].ZWDYGCZPY = dtTemp.Rows[N]["ZWDYGCZPY"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZWDYGCZPY"].ToString();
                 arrModel[N].ZWDYGCZPY_PD = dtTemp.Rows[N]["ZWDYGCZPY_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZWDYGCZPY_PD"].ToString();
                 arrModel[N].ZWDYGSPPY = dtTemp.Rows[N]["ZWDYGSPPY"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZWDYGSPPY"].ToString();
                 arrModel[N].ZWDYGSPPY_PD = dtTemp.Rows[N]["ZWDYGSPPY_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZWDYGSPPY_PD"].ToString();
                 arrModel[N].ZWDJGCZPYL = dtTemp.Rows[N]["ZWDJGCZPYL"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZWDJGCZPYL"].ToString();
                 arrModel[N].ZWDJGSPPYL = dtTemp.Rows[N]["ZWDJGSPPYL"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZWDJGSPPYL"].ToString();
                 arrModel[N].ZWDJGDG = dtTemp.Rows[N]["ZWDJGDG"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZWDJGDG"].ToString();
                 arrModel[N].ZWDJGCZPY = dtTemp.Rows[N]["ZWDJGCZPY"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZWDJGCZPY"].ToString();
                 arrModel[N].ZWDJGCZPY_PD = dtTemp.Rows[N]["ZWDJGCZPY_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZWDJGCZPY_PD"].ToString();
                 arrModel[N].ZWDJGSPPY = dtTemp.Rows[N]["ZWDJGSPPY"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZWDJGSPPY"].ToString();
                 arrModel[N].ZWDJGSPPY_PD = dtTemp.Rows[N]["ZWDJGSPPY_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZWDJGSPPY_PD"].ToString();
                 arrModel[N].ZWDZ_PD = dtTemp.Rows[N]["ZWDZ_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZWDZ_PD"].ToString();
                 arrModel[N].ZNDYGGQ = dtTemp.Rows[N]["ZNDYGGQ"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZNDYGGQ"].ToString();
                 arrModel[N].ZNDYGGQ_PD = dtTemp.Rows[N]["ZNDYGGQ_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZNDYGGQ_PD"].ToString();
                 arrModel[N].ZNDYGCZPYL = dtTemp.Rows[N]["ZNDYGCZPYL"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZNDYGCZPYL"].ToString();
                 arrModel[N].ZNDYGSPPYL = dtTemp.Rows[N]["ZNDYGSPPYL"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZNDYGSPPYL"].ToString();
                 arrModel[N].ZNDYGDG = dtTemp.Rows[N]["ZNDYGDG"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZNDYGDG"].ToString();
                 arrModel[N].ZNDYGCZPY = dtTemp.Rows[N]["ZNDYGCZPY"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZNDYGCZPY"].ToString();
                 arrModel[N].ZNDYGCZPY_PD = dtTemp.Rows[N]["ZNDYGCZPY_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZNDYGCZPY_PD"].ToString();
                 arrModel[N].ZNDYGSPPY = dtTemp.Rows[N]["ZNDYGSPPY"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZNDYGSPPY"].ToString();
                 arrModel[N].ZNDYGSPPY_PD = dtTemp.Rows[N]["ZNDYGSPPY_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZNDYGSPPY_PD"].ToString();
                 arrModel[N].ZNDJGCZPYL = dtTemp.Rows[N]["ZNDJGCZPYL"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZNDJGCZPYL"].ToString();
                 arrModel[N].ZNDJGSPPYL = dtTemp.Rows[N]["ZNDJGSPPYL"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZNDJGSPPYL"].ToString();
                 arrModel[N].ZNDJGDG = dtTemp.Rows[N]["ZNDJGDG"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZNDJGDG"].ToString();
                 arrModel[N].ZNDJGCZPY = dtTemp.Rows[N]["ZNDJGCZPY"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZNDJGCZPY"].ToString();
                 arrModel[N].ZNDJGCZPY_PD = dtTemp.Rows[N]["ZNDJGCZPY_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZNDJGCZPY_PD"].ToString();
                 arrModel[N].ZNDJGSPPY = dtTemp.Rows[N]["ZNDJGSPPY"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZNDJGSPPY"].ToString();
                 arrModel[N].ZNDJGSPPY_PD = dtTemp.Rows[N]["ZNDJGSPPY_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZNDJGSPPY_PD"].ToString();
                 arrModel[N].ZNDZ_PD = dtTemp.Rows[N]["ZNDZ_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZNDZ_PD"].ToString();
                 arrModel[N].YNDYGGQ = dtTemp.Rows[N]["YNDYGGQ"] == DBNull.Value ? "" : dtTemp.Rows[N]["YNDYGGQ"].ToString();
                 arrModel[N].YNDYGGQ_PD = dtTemp.Rows[N]["YNDYGGQ_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["YNDYGGQ_PD"].ToString();
                 arrModel[N].YNDYGCZPYL = dtTemp.Rows[N]["YNDYGCZPYL"] == DBNull.Value ? "" : dtTemp.Rows[N]["YNDYGCZPYL"].ToString();
                 arrModel[N].YNDYGSPPYL = dtTemp.Rows[N]["YNDYGSPPYL"] == DBNull.Value ? "" : dtTemp.Rows[N]["YNDYGSPPYL"].ToString();
                 arrModel[N].YNDYGDG = dtTemp.Rows[N]["YNDYGDG"] == DBNull.Value ? "" : dtTemp.Rows[N]["YNDYGDG"].ToString();
                 arrModel[N].YNDYGCZPY = dtTemp.Rows[N]["YNDYGCZPY"] == DBNull.Value ? "" : dtTemp.Rows[N]["YNDYGCZPY"].ToString();
                 arrModel[N].YNDYGCZPY_PD = dtTemp.Rows[N]["YNDYGCZPY_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["YNDYGCZPY_PD"].ToString();
                 arrModel[N].YNDYGSPPY = dtTemp.Rows[N]["YNDYGSPPY"] == DBNull.Value ? "" : dtTemp.Rows[N]["YNDYGSPPY"].ToString();
                 arrModel[N].YNDYGSPPY_PD = dtTemp.Rows[N]["YNDYGSPPY_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["YNDYGSPPY_PD"].ToString();
                 arrModel[N].YNDJGCZPYL = dtTemp.Rows[N]["YNDJGCZPYL"] == DBNull.Value ? "" : dtTemp.Rows[N]["YNDJGCZPYL"].ToString();
                 arrModel[N].YNDJGSPPYL = dtTemp.Rows[N]["YNDJGSPPYL"] == DBNull.Value ? "" : dtTemp.Rows[N]["YNDJGSPPYL"].ToString();
                 arrModel[N].YNDJGDG = dtTemp.Rows[N]["YNDJGDG"] == DBNull.Value ? "" : dtTemp.Rows[N]["YNDJGDG"].ToString();
                 arrModel[N].YNDJGCZPY = dtTemp.Rows[N]["YNDJGCZPY"] == DBNull.Value ? "" : dtTemp.Rows[N]["YNDJGCZPY"].ToString();
                 arrModel[N].YNDJGCZPY_PD = dtTemp.Rows[N]["YNDJGCZPY_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["YNDJGCZPY_PD"].ToString();
                 arrModel[N].YNDJGSPPY = dtTemp.Rows[N]["YNDJGSPPY"] == DBNull.Value ? "" : dtTemp.Rows[N]["YNDJGSPPY"].ToString();
                 arrModel[N].YNDJGSPPY_PD = dtTemp.Rows[N]["YNDJGSPPY_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["YNDJGSPPY_PD"].ToString();
                 arrModel[N].YNDZ_PD = dtTemp.Rows[N]["YNDZ_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["YNDZ_PD"].ToString();
                 arrModel[N].YWDYGGQ = dtTemp.Rows[N]["YWDYGGQ"] == DBNull.Value ? "" : dtTemp.Rows[N]["YWDYGGQ"].ToString();
                 arrModel[N].YWDYGGQ_PD = dtTemp.Rows[N]["YWDYGGQ_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["YWDYGGQ_PD"].ToString();
                 arrModel[N].YWDYGCZPYL = dtTemp.Rows[N]["YWDYGCZPYL"] == DBNull.Value ? "" : dtTemp.Rows[N]["YWDYGCZPYL"].ToString();
                 arrModel[N].YWDYGSPPYL = dtTemp.Rows[N]["YWDYGSPPYL"] == DBNull.Value ? "" : dtTemp.Rows[N]["YWDYGSPPYL"].ToString();
                 arrModel[N].YWDYGDG = dtTemp.Rows[N]["YWDYGDG"] == DBNull.Value ? "" : dtTemp.Rows[N]["YWDYGDG"].ToString();
                 arrModel[N].YWDYGCZPY = dtTemp.Rows[N]["YWDYGCZPY"] == DBNull.Value ? "" : dtTemp.Rows[N]["YWDYGCZPY"].ToString();
                 arrModel[N].YWDYGCZPY_PD = dtTemp.Rows[N]["YWDYGCZPY_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["YWDYGCZPY_PD"].ToString();
                 arrModel[N].YWDYGSPPY = dtTemp.Rows[N]["YWDYGSPPY"] == DBNull.Value ? "" : dtTemp.Rows[N]["YWDYGSPPY"].ToString();
                 arrModel[N].YWDYGSPPY_PD = dtTemp.Rows[N]["YWDYGSPPY_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["YWDYGSPPY_PD"].ToString();
                 arrModel[N].YWDJGCZPYL = dtTemp.Rows[N]["YWDJGCZPYL"] == DBNull.Value ? "" : dtTemp.Rows[N]["YWDJGCZPYL"].ToString();
                 arrModel[N].YWDJGSPPYL = dtTemp.Rows[N]["YWDJGSPPYL"] == DBNull.Value ? "" : dtTemp.Rows[N]["YWDJGSPPYL"].ToString();
                 arrModel[N].YWDJGDG = dtTemp.Rows[N]["YWDJGDG"] == DBNull.Value ? "" : dtTemp.Rows[N]["YWDJGDG"].ToString();
                 arrModel[N].YWDJGCZPY = dtTemp.Rows[N]["YWDJGCZPY"] == DBNull.Value ? "" : dtTemp.Rows[N]["YWDJGCZPY"].ToString();
                 arrModel[N].YWDJGCZPY_PD = dtTemp.Rows[N]["YWDJGCZPY_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["YWDJGCZPY_PD"].ToString();
                 arrModel[N].YWDJGSPPY = dtTemp.Rows[N]["YWDJGSPPY"] == DBNull.Value ? "" : dtTemp.Rows[N]["YWDJGSPPY"].ToString();
                 arrModel[N].YWDJGSPPY_PD = dtTemp.Rows[N]["YWDJGSPPY_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["YWDJGSPPY_PD"].ToString();
                 arrModel[N].YWDZ_PD = dtTemp.Rows[N]["YWDZ_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["YWDZ_PD"].ToString();
                 arrModel[N].DGZGQ = dtTemp.Rows[N]["DGZGQ"] == DBNull.Value ? "" : dtTemp.Rows[N]["DGZGQ"].ToString();
                 arrModel[N].DGZGQ_PD = dtTemp.Rows[N]["DGZGQ_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["DGZGQ_PD"].ToString();
                 arrModel[N].DGGQXZ = dtTemp.Rows[N]["DGGQXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["DGGQXZ"].ToString();
                 arrModel[N].YGCZPYXZXX = dtTemp.Rows[N]["YGCZPYXZXX"] == DBNull.Value ? "" : dtTemp.Rows[N]["YGCZPYXZXX"].ToString();
                 arrModel[N].YGCZPYXZSX = dtTemp.Rows[N]["YGCZPYXZSX"] == DBNull.Value ? "" : dtTemp.Rows[N]["YGCZPYXZSX"].ToString();
                 arrModel[N].YGZDZPXZ = dtTemp.Rows[N]["YGZDZPXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["YGZDZPXZ"].ToString();
                 arrModel[N].YGZDYPXZ = dtTemp.Rows[N]["YGZDYPXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["YGZDYPXZ"].ToString();
                 arrModel[N].YGYDZPXZ = dtTemp.Rows[N]["YGYDZPXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["YGYDZPXZ"].ToString();
                 arrModel[N].YGYDYPXZ = dtTemp.Rows[N]["YGYDYPXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["YGYDYPXZ"].ToString();
                 arrModel[N].JGCZPYXZXX = dtTemp.Rows[N]["JGCZPYXZXX"] == DBNull.Value ? "" : dtTemp.Rows[N]["JGCZPYXZXX"].ToString();
                 arrModel[N].JGCZPYXZSX = dtTemp.Rows[N]["JGCZPYXZSX"] == DBNull.Value ? "" : dtTemp.Rows[N]["JGCZPYXZSX"].ToString();
                 arrModel[N].JGZDZPXZ = dtTemp.Rows[N]["JGZDZPXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["JGZDZPXZ"].ToString();
                 arrModel[N].JGZDYPXZ = dtTemp.Rows[N]["JGZDYPXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["JGZDYPXZ"].ToString();
                 arrModel[N].JGYDZPXZ = dtTemp.Rows[N]["JGYDZPXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["JGYDZPXZ"].ToString();
                 arrModel[N].JGYDYPXZ = dtTemp.Rows[N]["JGYDYPXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["JGYDYPXZ"].ToString();
                 arrModel[N].ZGQXZ = dtTemp.Rows[N]["ZGQXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZGQXZ"].ToString();
                 arrModel[N].DGZ_PD = dtTemp.Rows[N]["DGZ_PD"] == DBNull.Value ? "" : dtTemp.Rows[N]["DGZ_PD"].ToString();
                 arrModel[N].KSSJ = dtTemp.Rows[N]["KSSJ"] == DBNull.Value ? "" : dtTemp.Rows[N]["KSSJ"].ToString();
                 arrModel[N].JSSJ = dtTemp.Rows[N]["JSSJ"] == DBNull.Value ? "" : dtTemp.Rows[N]["JSSJ"].ToString();
                 arrModel[N].BIG1000JGCZPYXZXX = dtTemp.Rows[N]["BIG1000JGCZPYXZXX"] == DBNull.Value ? "" : dtTemp.Rows[N]["BIG1000JGCZPYXZXX"].ToString();
                 arrModel[N].BIG1000JGCZPYXZSX = dtTemp.Rows[N]["BIG1000JGCZPYXZSX"] == DBNull.Value ? "" : dtTemp.Rows[N]["BIG1000JGCZPYXZSX"].ToString();
                 arrModel[N].ZWDDGGQXZ = dtTemp.Rows[N]["ZWDDGGQXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZWDDGGQXZ"].ToString();
                 arrModel[N].ZWDYGCZPYXZSX = dtTemp.Rows[N]["ZWDYGCZPYXZSX"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZWDYGCZPYXZSX"].ToString();
                 arrModel[N].ZWDYGCZPYXZXX = dtTemp.Rows[N]["ZWDYGCZPYXZXX"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZWDYGCZPYXZXX"].ToString();
                 arrModel[N].ZWDJGCZPYXZSX = dtTemp.Rows[N]["ZWDJGCZPYXZSX"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZWDJGCZPYXZSX"].ToString();
                 arrModel[N].ZWDJGCZPYXZXX = dtTemp.Rows[N]["ZWDJGCZPYXZXX"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZWDJGCZPYXZXX"].ToString();
                 arrModel[N].ZWDYGZDYPXZ = dtTemp.Rows[N]["ZWDYGZDYPXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZWDYGZDYPXZ"].ToString();
                 arrModel[N].ZWDYGZDZPXZ = dtTemp.Rows[N]["ZWDYGZDZPXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZWDYGZDZPXZ"].ToString();
                 arrModel[N].ZWDYGYDYPXZ = dtTemp.Rows[N]["ZWDYGYDYPXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZWDYGYDYPXZ"].ToString();
                 arrModel[N].ZWDYGYDZPXZ = dtTemp.Rows[N]["ZWDYGYDZPXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZWDYGYDZPXZ"].ToString();
                 arrModel[N].ZWDJGZDYPXZ = dtTemp.Rows[N]["ZWDJGZDYPXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZWDJGZDYPXZ"].ToString();
                 arrModel[N].ZWDJGZDZPXZ = dtTemp.Rows[N]["ZWDJGZDZPXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZWDJGZDZPXZ"].ToString();
                 arrModel[N].ZWDJGYDYPXZ = dtTemp.Rows[N]["ZWDJGYDYPXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZWDJGYDYPXZ"].ToString();
                 arrModel[N].ZWDJGYDZPXZ = dtTemp.Rows[N]["ZWDJGYDZPXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZWDJGYDZPXZ"].ToString();
                 arrModel[N].ZNDDGGQXZ = dtTemp.Rows[N]["ZNDDGGQXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZNDDGGQXZ"].ToString();
                 arrModel[N].ZNDYGCZPYXZSX = dtTemp.Rows[N]["ZNDYGCZPYXZSX"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZNDYGCZPYXZSX"].ToString();
                 arrModel[N].ZNDYGCZPYXZXX = dtTemp.Rows[N]["ZNDYGCZPYXZXX"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZNDYGCZPYXZXX"].ToString();
                 arrModel[N].ZNDJGCZPYXZSX = dtTemp.Rows[N]["ZNDJGCZPYXZSX"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZNDJGCZPYXZSX"].ToString();
                 arrModel[N].ZNDJGCZPYXZXX = dtTemp.Rows[N]["ZNDJGCZPYXZXX"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZNDJGCZPYXZXX"].ToString();
                 arrModel[N].ZNDYGZDYPXZ = dtTemp.Rows[N]["ZNDYGZDYPXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZNDYGZDYPXZ"].ToString();
                 arrModel[N].ZNDYGZDZPXZ = dtTemp.Rows[N]["ZNDYGZDZPXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZNDYGZDZPXZ"].ToString();
                 arrModel[N].ZNDYGYDYPXZ = dtTemp.Rows[N]["ZNDYGYDYPXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZNDYGYDYPXZ"].ToString();
                 arrModel[N].ZNDYGYDZPXZ = dtTemp.Rows[N]["ZNDYGYDZPXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZNDYGYDZPXZ"].ToString();
                 arrModel[N].ZNDJGZDYPXZ = dtTemp.Rows[N]["ZNDJGZDYPXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZNDJGZDYPXZ"].ToString();
                 arrModel[N].ZNDJGZDZPXZ = dtTemp.Rows[N]["ZNDJGZDZPXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZNDJGZDZPXZ"].ToString();
                 arrModel[N].ZNDJGYDYPXZ = dtTemp.Rows[N]["ZNDJGYDYPXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZNDJGYDYPXZ"].ToString();
                 arrModel[N].ZNDJGYDZPXZ = dtTemp.Rows[N]["ZNDJGYDZPXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["ZNDJGYDZPXZ"].ToString();
                 arrModel[N].YNDDGGQXZ = dtTemp.Rows[N]["YNDDGGQXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["YNDDGGQXZ"].ToString();
                 arrModel[N].YNDYGCZPYXZSX = dtTemp.Rows[N]["YNDYGCZPYXZSX"] == DBNull.Value ? "" : dtTemp.Rows[N]["YNDYGCZPYXZSX"].ToString();
                 arrModel[N].YNDYGCZPYXZXX = dtTemp.Rows[N]["YNDYGCZPYXZXX"] == DBNull.Value ? "" : dtTemp.Rows[N]["YNDYGCZPYXZXX"].ToString();
                 arrModel[N].YNDJGCZPYXZSX = dtTemp.Rows[N]["YNDJGCZPYXZSX"] == DBNull.Value ? "" : dtTemp.Rows[N]["YNDJGCZPYXZSX"].ToString();
                 arrModel[N].YNDJGCZPYXZXX = dtTemp.Rows[N]["YNDJGCZPYXZXX"] == DBNull.Value ? "" : dtTemp.Rows[N]["YNDJGCZPYXZXX"].ToString();
                 arrModel[N].YNDYGZDYPXZ = dtTemp.Rows[N]["YNDYGZDYPXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["YNDYGZDYPXZ"].ToString();
                 arrModel[N].YNDYGZDZPXZ = dtTemp.Rows[N]["YNDYGZDZPXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["YNDYGZDZPXZ"].ToString();
                 arrModel[N].YNDYGYDYPXZ = dtTemp.Rows[N]["YNDYGYDYPXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["YNDYGYDYPXZ"].ToString();
                 arrModel[N].YNDYGYDZPXZ = dtTemp.Rows[N]["YNDYGYDZPXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["YNDYGYDZPXZ"].ToString();
                 arrModel[N].YNDJGZDYPXZ = dtTemp.Rows[N]["YNDJGZDYPXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["YNDJGZDYPXZ"].ToString();
                 arrModel[N].YNDJGZDZPXZ = dtTemp.Rows[N]["YNDJGZDZPXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["YNDJGZDZPXZ"].ToString();
                 arrModel[N].YNDJGYDYPXZ = dtTemp.Rows[N]["YNDJGYDYPXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["YNDJGYDYPXZ"].ToString();
                 arrModel[N].YNDJGYDZPXZ = dtTemp.Rows[N]["YNDJGYDZPXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["YNDJGYDZPXZ"].ToString();
                 arrModel[N].YWDDGGQXZ = dtTemp.Rows[N]["YWDDGGQXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["YWDDGGQXZ"].ToString();
                 arrModel[N].YWDYGCZPYXZSX = dtTemp.Rows[N]["YWDYGCZPYXZSX"] == DBNull.Value ? "" : dtTemp.Rows[N]["YWDYGCZPYXZSX"].ToString();
                 arrModel[N].YWDYGCZPYXZXX = dtTemp.Rows[N]["YWDYGCZPYXZXX"] == DBNull.Value ? "" : dtTemp.Rows[N]["YWDYGCZPYXZXX"].ToString();
                 arrModel[N].YWDJGCZPYXZSX = dtTemp.Rows[N]["YWDJGCZPYXZSX"] == DBNull.Value ? "" : dtTemp.Rows[N]["YWDJGCZPYXZSX"].ToString();
                 arrModel[N].YWDJGCZPYXZXX = dtTemp.Rows[N]["YWDJGCZPYXZXX"] == DBNull.Value ? "" : dtTemp.Rows[N]["YWDJGCZPYXZXX"].ToString();
                 arrModel[N].YWDYGZDYPXZ = dtTemp.Rows[N]["YWDYGZDYPXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["YWDYGZDYPXZ"].ToString();
                 arrModel[N].YWDYGZDZPXZ = dtTemp.Rows[N]["YWDYGZDZPXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["YWDYGZDZPXZ"].ToString();
                 arrModel[N].YWDYGYDYPXZ = dtTemp.Rows[N]["YWDYGYDYPXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["YWDYGYDYPXZ"].ToString();
                 arrModel[N].YWDYGYDZPXZ = dtTemp.Rows[N]["YWDYGYDZPXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["YWDYGYDZPXZ"].ToString();
                 arrModel[N].YWDJGZDYPXZ = dtTemp.Rows[N]["YWDJGZDYPXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["YWDJGZDYPXZ"].ToString();
                 arrModel[N].YWDJGZDZPXZ = dtTemp.Rows[N]["YWDJGZDZPXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["YWDJGZDZPXZ"].ToString();
                 arrModel[N].YWDJGYDYPXZ = dtTemp.Rows[N]["YWDJGYDYPXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["YWDJGYDYPXZ"].ToString();
                 arrModel[N].YWDJGYDZPXZ = dtTemp.Rows[N]["YWDJGYDZPXZ"] == DBNull.Value ? "" : dtTemp.Rows[N]["YWDJGYDZPXZ"].ToString();
          }

          dtTemp.Dispose();

          return arrModel;
      }

      /// <summary>
      /// 得到对象集合
      /// </summary>
      public RESULT_LAMP[] GetModelList(string p_strWhere)
      {
          return GetModelList(p_strWhere, "", -1, -1);
      }

      /// <summary>
      /// 得到对象集合
      /// </summary>
      public RESULT_LAMP[] GetModelList(string p_strWhere, string p_strOrder)
      {
          return GetModelList(p_strWhere, p_strOrder, -1, -1);
      }

      /// <summary>
      /// 得到对象集合
      /// </summary>
      public RESULT_LAMP[] GetModelList(int p_intPageNumber, int p_intPageSize)
      {
          return GetModelList("", "", p_intPageNumber, p_intPageSize);
      }

      /// <summary>
      /// 得到对象集合
      /// </summary>
      public RESULT_LAMP[] GetModelList(string p_strWhere, int p_intPageNumber, int p_intPageSize)
      {
          return GetModelList(p_strWhere, "", p_intPageNumber, p_intPageSize);
      }

      /// <summary>
      /// 得到对象集合
      /// </summary>
      public RESULT_LAMP[] GetModelList()
      {
          return GetModelList("", "", -1, -1);
      }

      /// <summary>
      /// 得到对象集合
      /// </summary>
      public void GetModelList(ref DataTable p_dtData, string p_strWhere, string p_strOrder, int p_intPageNumber, int p_intPageSize)
      {
          p_dtData.Clear();

          int m_intPageNumber = p_intPageNumber;
          int m_intPageCount = GetPageCount(p_strWhere, p_intPageSize);

          if((m_intPageNumber < 1) || (m_intPageNumber == 0))
          {
              m_intPageNumber = 1;
          }

          if(m_intPageNumber == -1)
          {
              m_intPageNumber = m_intPageCount;
          }

          if(m_intPageNumber > m_intPageCount)
          {
              m_intPageNumber = m_intPageCount;
          }

          string strSql = "";
          strSql += "select * from RESULT_LAMP";
          if(p_strWhere.Trim().Length > 0)
          {
              strSql += " where " + p_strWhere;
          }
          if(p_strOrder.Trim().Length > 0)
          {
              strSql += " order by " + p_strOrder;
          }

          if(p_intPageSize > 0)
          {
              DbHelper.GetTable(strSql, ref p_dtData, (m_intPageNumber-1)*p_intPageSize, p_intPageSize);
          }
          else
          {
              DbHelper.GetTable(strSql, ref p_dtData);
          }
       }

       /// <summary>
       /// 得到对象集合
       /// </summary>
       public void GetModelList(ref DataTable p_dtData, string p_strWhere)
       {
           GetModelList(ref p_dtData, p_strWhere, "", -1, -1);
       }

       /// <summary>
       /// 得到对象集合
       /// </summary>
       public void GetModelList(ref DataTable p_dtData, string p_strWhere, string p_strOrder)
       {
           GetModelList(ref p_dtData, p_strWhere, p_strOrder, -1, -1);
       }

       /// <summary>
       /// 得到对象集合
       /// </summary>
       public void GetModelList(ref DataTable p_dtData, int p_intPageNumber, int p_intPageSize)
       {
           GetModelList(ref p_dtData, "", "", p_intPageNumber, p_intPageSize);
       }

       /// <summary>
       /// 得到对象集合
       /// </summary>
       public void GetModelList(ref DataTable p_dtData, string p_strWhere, int p_intPageNumber, int p_intPageSize)
       {
           GetModelList(ref p_dtData, p_strWhere, "", p_intPageNumber, p_intPageSize);
       }
       /// <summary>
       /// 得到对象集合
       /// </summary>
       public void GetModelList(ref DataTable p_dtData)
       {
           GetModelList(ref p_dtData, "", "", -1, -1);
       }
   }
}
